SQL (132 queries) Time (85.44ms) Bindings Trace
select * from `product_pharmgroups` where `alias` = ? limit 1 4.22ms
array:1 [
  0 => "gemorroy"
]
select count(*) as aggregate from `products` where `ProductName` LIKE ? and `pharmgroupID` in (?) 1.14ms
array:2 [
  0 => "%"
  1 => 82
]
select * from `products` where `ProductName` LIKE ? and `pharmgroupID` in (?) limit 20 offset 0 1.94ms
array:2 [
  0 => "%"
  1 => 82
]
select * from `product_comments` where `product_comments`.`ProductCommentsProductID` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 1.19ms
array:20 [
  0 => 447
  1 => 453
  2 => 480
  3 => 615
  4 => 1253
  5 => 2092
  6 => 3330
  7 => 3401
  8 => 3428
  9 => 3777
  10 => 4003
  11 => 4004
  12 => 4068
  13 => 4069
  14 => 4070
  15 => 4071
  16 => 4216
  17 => 4218
  18 => 4219
  19 => 4220
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.8ms
array:1 [
  0 => 1
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.88ms
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.75ms
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.48ms
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.54ms
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.49ms
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.54ms
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.54ms
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.55ms
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.53ms
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.5ms
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.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.51ms
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.48ms
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.47ms
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.48ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.71ms
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.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.5ms
array:2 [
  0 => 18
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.45ms
array:2 [
  0 => 1
  1 => 18
]
select * from `image` where `image`.`id` in (?) 0.63ms
array:1 [
  0 => "320_100_calcium"
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.45ms
array:1 [
  0 => 5
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.52ms
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.5ms
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.49ms
array:2 [
  0 => 6
  1 => 2
]
select * from `atx` where `atx`.`id` = ? limit 1 0.76ms
array:1 [
  0 => "186"
]
select * from `mnn` where `mnn`.`MnnID` = ? limit 1 0.69ms
array:1 [
  0 => 648
]
select * from `pharmgroup` where `pharmgroup`.`PharmgroupID` = ? limit 1 0.69ms
array:1 [
  0 => 82
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.45ms
array:1 [
  0 => 447
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.57ms
array:3 [
  0 => "186"
  1 => 447
  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 => 453
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.9ms
array:3 [
  0 => "188"
  1 => 453
  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 => 480
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.94ms
array:3 [
  0 => "188"
  1 => 480
  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 => 615
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.56ms
array:3 [
  0 => "1491"
  1 => 615
  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 => 1253
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.99ms
array:3 [
  0 => "385"
  1 => 1253
  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 => 2092
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.2ms
array:3 [
  0 => "206"
  1 => 2092
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.43ms
array:1 [
  0 => 3330
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.62ms
array:3 [
  0 => "545"
  1 => 3330
  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 => 3401
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.68ms
array:3 [
  0 => "971"
  1 => 3401
  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 => 3428
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.95ms
array:3 [
  0 => "385"
  1 => 3428
  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 => 3777
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.75ms
array:3 [
  0 => "384"
  1 => 3777
  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 => 4003
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.74ms
array:3 [
  0 => "384"
  1 => 4003
  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 => 4004
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.74ms
array:3 [
  0 => "384"
  1 => 4004
  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 => 4068
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.66ms
array:3 [
  0 => "971"
  1 => 4068
  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 => 4069
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.66ms
array:3 [
  0 => "971"
  1 => 4069
  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 => 4070
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.95ms
array:3 [
  0 => "385"
  1 => 4070
  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 => 4071
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.92ms
array:3 [
  0 => "385"
  1 => 4071
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.43ms
array:1 [
  0 => 4216
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.89ms
array:3 [
  0 => "188"
  1 => 4216
  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 => 4218
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.92ms
array:3 [
  0 => "188"
  1 => 4218
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.43ms
array:1 [
  0 => 4219
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.89ms
array:3 [
  0 => "188"
  1 => 4219
  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 => 4220
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.88ms
array:3 [
  0 => "188"
  1 => 4220
  2 => 4
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.46ms
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.5ms
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.47ms
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.48ms
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.49ms
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.51ms
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.5ms
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.52ms
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.51ms
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` = ? 1.55ms
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` = ? 0.51ms
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 => 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.51ms
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.48ms
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.49ms
array:2 [
  0 => 0
  1 => 17
]
select * from `image` where `image`.`id` in (?) 0.46ms
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.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.5ms
array:2 [
  0 => 18
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.51ms
array:2 [
  0 => 0
  1 => 18
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.46ms
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.51ms
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.55ms
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.5ms
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.52ms
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.53ms
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` = ? 1.6ms
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.47ms
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 => 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.5ms
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 => 20
  1 => 2
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.48ms
array:1 [
  0 => 2
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.58ms
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.58ms
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.49ms
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.53ms
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.5ms
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.49ms
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.5ms
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 => 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.48ms
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.52ms
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.5ms
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 (?) 1.68ms
array:2 [
  0 => 0
  1 => 6
]
select * from `product_pharmgroups` order by `pharmgroupName` asc 1.44ms
[]