G03D - ПРОГЕСТОГЕНЫ, ИСКЛЮЧАЯ G3A, G3F

SQL (118 queries) Time (146.45ms) Bindings Trace
select * from `pharmgroup` where `alias` = ? limit 1 4.63ms
array:1 [
  0 => "g03d---progestogeny-isklyuchaya-g3a-g3f"
]
select count(*) as aggregate from `products` where `ProductName` LIKE ? and `pharmgroupID` = ? 0.91ms
array:2 [
  0 => "%"
  1 => 19
]
select * from `products` where `ProductName` LIKE ? and `pharmgroupID` = ? limit 20 offset 0 1.36ms
array:2 [
  0 => "%"
  1 => 19
]
select * from `product_comments` where `product_comments`.`ProductCommentsProductID` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 1.11ms
array:13 [
  0 => 1027
  1 => 1777
  2 => 2559
  3 => 3539
  4 => 3605
  5 => 4058
  6 => 4063
  7 => 4064
  8 => 5203
  9 => 5886
  10 => 7015
  11 => 7016
  12 => 7017
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 10.29ms
array:1 [
  0 => 1
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 17.33ms
array:2 [
  0 => 0
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 8.76ms
array:2 [
  0 => 2
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.61ms
array:2 [
  0 => 2
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.53ms
array:2 [
  0 => 4
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.47ms
array:2 [
  0 => 4
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.49ms
array:2 [
  0 => 8
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.45ms
array:2 [
  0 => 8
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.47ms
array:2 [
  0 => 9
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.46ms
array:2 [
  0 => 9
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.47ms
array:2 [
  0 => 12
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.46ms
array:2 [
  0 => 12
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.48ms
array:2 [
  0 => 13
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.5ms
array:2 [
  0 => 13
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.77ms
array:2 [
  0 => 13
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.49ms
array:2 [
  0 => 14
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.46ms
array:2 [
  0 => 16
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.49ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 8.07ms
array:2 [
  0 => 1
  1 => 17
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.62ms
array:2 [
  0 => 16
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.47ms
array:2 [
  0 => 18
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.5ms
array:2 [
  0 => 1
  1 => 18
]
select * from `image` where `image`.`id` in (?) 5.9ms
array:1 [
  0 => "320_100_calcium"
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.57ms
array:1 [
  0 => 5
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.64ms
array:2 [
  0 => 0
  1 => 5
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.58ms
array:2 [
  0 => 6
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.55ms
array:2 [
  0 => 6
  1 => 2
]
select * from `atx` where `atx`.`id` = ? limit 1 0.51ms
array:1 [
  0 => "404"
]
select * from `mnn` where `mnn`.`MnnID` = ? limit 1 0.79ms
array:1 [
  0 => 328
]
select * from `pharmgroup` where `pharmgroup`.`PharmgroupID` = ? limit 1 0.58ms
array:1 [
  0 => 19
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.46ms
array:1 [
  0 => 1027
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.78ms
array:3 [
  0 => "404"
  1 => 1027
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.56ms
array:1 [
  0 => 1777
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.65ms
array:3 [
  0 => "640"
  1 => 1777
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.51ms
array:1 [
  0 => 2559
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.94ms
array:3 [
  0 => "797"
  1 => 2559
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.45ms
array:1 [
  0 => 3539
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.59ms
array:3 [
  0 => "1004"
  1 => 3539
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.42ms
array:1 [
  0 => 3605
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.56ms
array:3 [
  0 => "1017"
  1 => 3605
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.41ms
array:1 [
  0 => 4058
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.87ms
array:3 [
  0 => "797"
  1 => 4058
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.42ms
array:1 [
  0 => 4063
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.93ms
array:3 [
  0 => "797"
  1 => 4063
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.42ms
array:1 [
  0 => 4064
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.86ms
array:3 [
  0 => "797"
  1 => 4064
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.41ms
array:1 [
  0 => 5203
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.92ms
array:3 [
  0 => "797"
  1 => 5203
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.42ms
array:1 [
  0 => 5886
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.87ms
array:3 [
  0 => "797"
  1 => 5886
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.39ms
array:1 [
  0 => 7015
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.94ms
array:3 [
  0 => "797"
  1 => 7015
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.4ms
array:1 [
  0 => 7016
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.9ms
array:3 [
  0 => "797"
  1 => 7016
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.39ms
array:1 [
  0 => 7017
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.89ms
array:3 [
  0 => "797"
  1 => 7017
  2 => 4
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.43ms
array:1 [
  0 => 1
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.57ms
array:2 [
  0 => 0
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.48ms
array:2 [
  0 => 2
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.46ms
array:2 [
  0 => 2
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.55ms
array:2 [
  0 => 4
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.46ms
array:2 [
  0 => 4
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.48ms
array:2 [
  0 => 8
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.44ms
array:2 [
  0 => 8
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.49ms
array:2 [
  0 => 9
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.5ms
array:2 [
  0 => 9
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.49ms
array:2 [
  0 => 12
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.44ms
array:2 [
  0 => 12
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 9.9ms
array:2 [
  0 => 13
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 11.52ms
array:2 [
  0 => 13
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.76ms
array:2 [
  0 => 13
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.55ms
array:2 [
  0 => 14
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.45ms
array:2 [
  0 => 16
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.73ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.47ms
array:2 [
  0 => 0
  1 => 17
]
select * from `image` where `image`.`id` in (?) 0.91ms
array:1 [
  0 => "14_Nikomed_RUS_240x400_Pharmprice_Canvas"
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.45ms
array:2 [
  0 => 16
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.47ms
array:2 [
  0 => 18
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.48ms
array:2 [
  0 => 0
  1 => 18
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.78ms
array:1 [
  0 => 2
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.59ms
array:2 [
  0 => 0
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.98ms
array:2 [
  0 => 3
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.53ms
array:2 [
  0 => 3
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.56ms
array:2 [
  0 => 10
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.5ms
array:2 [
  0 => 10
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.51ms
array:2 [
  0 => 11
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.59ms
array:2 [
  0 => 11
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.52ms
array:2 [
  0 => 13
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.48ms
array:2 [
  0 => 15
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.48ms
array:2 [
  0 => 13
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.47ms
array:2 [
  0 => 16
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.55ms
array:2 [
  0 => 16
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.53ms
array:2 [
  0 => 19
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.51ms
array:2 [
  0 => 16
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.54ms
array:2 [
  0 => 20
  1 => 2
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.51ms
array:1 [
  0 => 2
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.79ms
array:2 [
  0 => 0
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.64ms
array:2 [
  0 => 3
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 2.07ms
array:2 [
  0 => 3
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.55ms
array:2 [
  0 => 10
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.5ms
array:2 [
  0 => 10
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.54ms
array:2 [
  0 => 11
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.48ms
array:2 [
  0 => 11
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.48ms
array:2 [
  0 => 13
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.46ms
array:2 [
  0 => 15
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.49ms
array:2 [
  0 => 13
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.56ms
array:2 [
  0 => 16
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.45ms
array:2 [
  0 => 16
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.5ms
array:2 [
  0 => 19
  1 => 2
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.49ms
array:2 [
  0 => 16
  1 => 1
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.6ms
array:2 [
  0 => 20
  1 => 2
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.52ms
array:1 [
  0 => 6
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.6ms
array:2 [
  0 => 0
  1 => 6
]
select * from `product_pharmgroups` order by `pharmgroupName` asc 5.49ms
[]