SQL (119 queries) Time (91.25ms) Bindings Trace
select count(*) as aggregate from `products` 6.53ms
[]
select * from `products` where `ProductName` LIKE ? limit 20 offset 0 1.5ms
array:1 [
  0 => "%"
]
select * from `product_comments` where `product_comments`.`ProductCommentsProductID` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 1.45ms
array:20 [
  0 => 1
  1 => 2
  2 => 3
  3 => 4
  4 => 5
  5 => 7
  6 => 8
  7 => 9
  8 => 10
  9 => 11
  10 => 12
  11 => 13
  12 => 14
  13 => 16
  14 => 17
  15 => 18
  16 => 19
  17 => 20
  18 => 9893
  19 => 9894
]
select * from `banner_to_rules` where `banner_to_rules`.`entity_id` = ? and `banner_to_rules`.`entity_id` is not null and `entity_type` = ? 0.97ms
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.46ms
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.54ms
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.5ms
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.47ms
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.5ms
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.48ms
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.48ms
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.47ms
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 => 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.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.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.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.58ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.55ms
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.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.49ms
array:2 [
  0 => 18
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.51ms
array:2 [
  0 => 1
  1 => 18
]
select * from `image` where `image`.`id` in (?) 0.77ms
array:1 [
  0 => "320_100_calcium"
]
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 => 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.83ms
array:1 [
  0 => "1"
]
select * from `mnn` where `mnn`.`MnnID` = ? limit 1 2.52ms
array:1 [
  0 => 1
]
select * from `pharmgroup` where `pharmgroup`.`PharmgroupID` = ? limit 1 0.8ms
array:1 [
  0 => 26
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.52ms
array:1 [
  0 => 1
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.68ms
array:3 [
  0 => "1"
  1 => 1
  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 => 2
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.64ms
array:3 [
  0 => "2"
  1 => 2
  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 => 3
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.65ms
array:3 [
  0 => "3"
  1 => 3
  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 => 4
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.71ms
array:3 [
  0 => "5"
  1 => 4
  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 => 5
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 6.34ms
array:3 [
  0 => ""
  1 => 5
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.36ms
array:1 [
  0 => 9893
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 6.5ms
array:3 [
  0 => ""
  1 => 9893
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.37ms
array:1 [
  0 => 9894
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 6.35ms
array:3 [
  0 => ""
  1 => 9894
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.36ms
array:1 [
  0 => 7
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.57ms
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 0.37ms
array:1 [
  0 => 8
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.63ms
array:3 [
  0 => "533"
  1 => 8
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.34ms
array:1 [
  0 => 9
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.58ms
array:3 [
  0 => "361"
  1 => 9
  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 => 10
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.65ms
array:3 [
  0 => "7"
  1 => 10
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.36ms
array:1 [
  0 => 11
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.67ms
array:3 [
  0 => "8"
  1 => 11
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.38ms
array:1 [
  0 => 12
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.79ms
array:3 [
  0 => "8"
  1 => 12
  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 => 13
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.7ms
array:3 [
  0 => "8"
  1 => 13
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.34ms
array:1 [
  0 => 14
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.86ms
array:3 [
  0 => "9"
  1 => 14
  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 => 16
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.01ms
array:3 [
  0 => "10"
  1 => 16
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.35ms
array:1 [
  0 => 17
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1ms
array:3 [
  0 => "10"
  1 => 17
  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 => 18
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 2.15ms
array:3 [
  0 => "10"
  1 => 18
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.38ms
array:1 [
  0 => 19
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1ms
array:3 [
  0 => "10"
  1 => 19
  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 => 20
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.97ms
array:3 [
  0 => "10"
  1 => 20
  2 => 4
]
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 => 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.4ms
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.45ms
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.38ms
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.42ms
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.47ms
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.43ms
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.4ms
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.43ms
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.45ms
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.4ms
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.39ms
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.4ms
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.4ms
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.38ms
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.41ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.42ms
array:2 [
  0 => 0
  1 => 17
]
select * from `image` where `image`.`id` in (?) 0.47ms
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.43ms
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.39ms
array:2 [
  0 => 18
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.37ms
array:2 [
  0 => 0
  1 => 18
]
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 => 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.39ms
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.42ms
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.42ms
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.41ms
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.45ms
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.43ms
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.39ms
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.43ms
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.39ms
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.4ms
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.42ms
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.39ms
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.42ms
array:2 [
  0 => 20
  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.43ms
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.44ms
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.44ms
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.39ms
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.67ms
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.4ms
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.39ms
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.43ms
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.43ms
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.42ms
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.39ms
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.4ms
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.43ms
array:2 [
  0 => 20
  1 => 2
]
select * from `product_pharmgroups` order by `pharmgroupName` asc 1.13ms
[]