SQL (132 queries) Time (103.7ms) Bindings Trace
select * from `product_pharmgroups` where `alias` = ? limit 1 4.3ms
array:1 [
  0 => "serdechno-sosudistye"
]
select count(*) as aggregate from `products` where `ProductName` LIKE ? and `pharmgroupID` in (?, ?, ?, ?, ?, ?) 3.25ms
array:7 [
  0 => "%"
  1 => 224
  2 => 143
  3 => 229
  4 => 24
  5 => 124
  6 => 75
]
select * from `products` where `ProductName` LIKE ? and `pharmgroupID` in (?, ?, ?, ?, ?, ?) limit 20 offset 0 1.93ms
array:7 [
  0 => "%"
  1 => 224
  2 => 143
  3 => 229
  4 => 24
  5 => 124
  6 => 75
]
select * from `product_comments` where `product_comments`.`ProductCommentsProductID` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 1.16ms
array:20 [
  0 => 7
  1 => 247
  2 => 248
  3 => 823
  4 => 824
  5 => 904
  6 => 905
  7 => 907
  8 => 2521
  9 => 4027
  10 => 4151
  11 => 4292
  12 => 4293
  13 => 5069
  14 => 5073
  15 => 5077
  16 => 5078
  17 => 5080
  18 => 5081
  19 => 5082
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 1.11ms
array:1 [
  0 => 1
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 1.35ms
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.7ms
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.5ms
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` = ? 1.34ms
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.64ms
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.65ms
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.58ms
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.67ms
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.64ms
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.63ms
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.73ms
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` = ? 1.89ms
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.64ms
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.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.57ms
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.58ms
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.69ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.8ms
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.66ms
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.61ms
array:2 [
  0 => 18
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.72ms
array:2 [
  0 => 1
  1 => 18
]
select * from `image` where `image`.`id` in (?) 0.73ms
array:1 [
  0 => "320_100_calcium"
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.58ms
array:1 [
  0 => 5
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.71ms
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.64ms
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.59ms
array:2 [
  0 => 6
  1 => 2
]
select * from `atx` where `atx`.`id` = ? limit 1 1.04ms
array:1 [
  0 => "789"
]
select * from `mnn` where `mnn`.`MnnID` = ? limit 1 1.01ms
array:1 [
  0 => 692
]
select * from `pharmgroup` where `pharmgroup`.`PharmgroupID` = ? limit 1 1ms
array:1 [
  0 => 24
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.54ms
array:1 [
  0 => 2521
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.77ms
array:3 [
  0 => "789"
  1 => 2521
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.49ms
array:1 [
  0 => 4027
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.65ms
array:3 [
  0 => "1088"
  1 => 4027
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.6ms
array:1 [
  0 => 4151
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.83ms
array:3 [
  0 => "1110"
  1 => 4151
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.58ms
array:1 [
  0 => 4292
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.18ms
array:3 [
  0 => "1088"
  1 => 4292
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.49ms
array:1 [
  0 => 4293
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.25ms
array:3 [
  0 => "1088"
  1 => 4293
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.5ms
array:1 [
  0 => 5069
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.59ms
array:3 [
  0 => "1088"
  1 => 5069
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.55ms
array:1 [
  0 => 5073
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.42ms
array:3 [
  0 => "1088"
  1 => 5073
  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 => 5077
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.31ms
array:3 [
  0 => "1088"
  1 => 5077
  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 => 5078
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.21ms
array:3 [
  0 => "1088"
  1 => 5078
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.6ms
array:1 [
  0 => 5080
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.24ms
array:3 [
  0 => "1088"
  1 => 5080
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.52ms
array:1 [
  0 => 5081
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.5ms
array:3 [
  0 => "1088"
  1 => 5081
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.52ms
array:1 [
  0 => 5082
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.42ms
array:3 [
  0 => "1088"
  1 => 5082
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.44ms
array:1 [
  0 => 7
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.71ms
array:3 [
  0 => "6"
  1 => 7
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 2.34ms
array:1 [
  0 => 247
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.83ms
array:3 [
  0 => "120"
  1 => 247
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.62ms
array:1 [
  0 => 248
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.69ms
array:3 [
  0 => "120"
  1 => 248
  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 => 823
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.69ms
array:3 [
  0 => "329"
  1 => 823
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.47ms
array:1 [
  0 => 824
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.72ms
array:3 [
  0 => "329"
  1 => 824
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.46ms
array:1 [
  0 => 904
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.27ms
array:3 [
  0 => "328"
  1 => 904
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.49ms
array:1 [
  0 => 905
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.28ms
array:3 [
  0 => "328"
  1 => 905
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.46ms
array:1 [
  0 => 907
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.3ms
array:3 [
  0 => "328"
  1 => 907
  2 => 4
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.49ms
array:1 [
  0 => 1
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.62ms
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.58ms
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.54ms
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.51ms
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.58ms
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.53ms
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.54ms
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.52ms
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.59ms
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.54ms
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.55ms
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.54ms
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.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.53ms
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.52ms
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.51ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.51ms
array:2 [
  0 => 0
  1 => 17
]
select * from `image` where `image`.`id` in (?) 0.51ms
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.54ms
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 => 18
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.49ms
array:2 [
  0 => 0
  1 => 18
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.56ms
array:1 [
  0 => 2
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.57ms
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.55ms
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.52ms
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.54ms
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.53ms
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.56ms
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.53ms
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.54ms
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.52ms
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.68ms
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.57ms
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.59ms
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.59ms
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.59ms
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.55ms
array:2 [
  0 => 20
  1 => 2
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.52ms
array:1 [
  0 => 2
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.84ms
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.6ms
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.52ms
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.54ms
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.53ms
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.53ms
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.68ms
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.69ms
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.88ms
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.71ms
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.67ms
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.64ms
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.57ms
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.48ms
array:1 [
  0 => 6
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.58ms
array:2 [
  0 => 0
  1 => 6
]
select * from `product_pharmgroups` order by `pharmgroupName` asc 1.07ms
[]