SQL (132 queries) Time (138.43ms) Bindings Trace
select * from `product_pharmgroups` where `alias` = ? limit 1 7.9ms
array:1 [
  0 => "dermatologiya"
]
select count(*) as aggregate from `products` where `ProductName` LIKE ? and `pharmgroupID` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 8.59ms
array:15 [
  0 => "%"
  1 => 65
  2 => 222
  3 => 22
  4 => 116
  5 => 185
  6 => 204
  7 => 118
  8 => 123
  9 => 121
  10 => 115
  11 => 29
  12 => 86
  13 => 97
  14 => 144
]
select * from `products` where `ProductName` LIKE ? and `pharmgroupID` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) limit 20 offset 0 1.95ms
array:15 [
  0 => "%"
  1 => 65
  2 => 222
  3 => 22
  4 => 116
  5 => 185
  6 => 204
  7 => 118
  8 => 123
  9 => 121
  10 => 115
  11 => 29
  12 => 86
  13 => 97
  14 => 144
]
select * from `product_comments` where `product_comments`.`ProductCommentsProductID` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 1.25ms
array:20 [
  0 => 43
  1 => 175
  2 => 176
  3 => 177
  4 => 488
  5 => 709
  6 => 710
  7 => 711
  8 => 1429
  9 => 1495
  10 => 1503
  11 => 2120
  12 => 2511
  13 => 2604
  14 => 2605
  15 => 2943
  16 => 3079
  17 => 3080
  18 => 3081
  19 => 3815
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 4.93ms
array:1 [
  0 => 1
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 16.34ms
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` = ? 10.23ms
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.69ms
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.52ms
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.5ms
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.49ms
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.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.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.51ms
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.87ms
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.61ms
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.56ms
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.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.51ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 4.45ms
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.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.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 => 1
  1 => 18
]
select * from `image` where `image`.`id` in (?) 4.39ms
array:1 [
  0 => "320_100_calcium"
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.55ms
array:1 [
  0 => 5
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.62ms
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.56ms
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.51ms
array:2 [
  0 => 6
  1 => 2
]
select * from `atx` where `atx`.`id` = ? limit 1 0.85ms
array:1 [
  0 => "20"
]
select * from `mnn` where `mnn`.`MnnID` = ? limit 1 0.82ms
array:1 [
  0 => 1037
]
select * from `pharmgroup` where `pharmgroup`.`PharmgroupID` = ? limit 1 0.92ms
array:1 [
  0 => 22
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.48ms
array:1 [
  0 => 43
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.29ms
array:3 [
  0 => "20"
  1 => 43
  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 => 175
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.13ms
array:3 [
  0 => "205"
  1 => 175
  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 => 176
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.06ms
array:3 [
  0 => "205"
  1 => 176
  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 => 177
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.13ms
array:3 [
  0 => "205"
  1 => 177
  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 => 488
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.35ms
array:3 [
  0 => "206"
  1 => 488
  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 => 709
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.93ms
array:3 [
  0 => "285"
  1 => 709
  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 => 710
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.83ms
array:3 [
  0 => "285"
  1 => 710
  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 => 711
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.17ms
array:3 [
  0 => "20"
  1 => 711
  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 => 1429
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.66ms
array:3 [
  0 => "545"
  1 => 1429
  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 => 1495
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.69ms
array:3 [
  0 => "570"
  1 => 1495
  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 => 1503
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 2.18ms
array:3 [
  0 => "216"
  1 => 1503
  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 => 2120
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.26ms
array:3 [
  0 => "206"
  1 => 2120
  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 => 2511
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.18ms
array:3 [
  0 => "20"
  1 => 2511
  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 => 2604
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.64ms
array:3 [
  0 => "810"
  1 => 2604
  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 => 2605
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.61ms
array:3 [
  0 => "810"
  1 => 2605
  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 => 2943
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.18ms
array:3 [
  0 => "20"
  1 => 2943
  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 => 3079
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.06ms
array:3 [
  0 => "205"
  1 => 3079
  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 => 3080
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.16ms
array:3 [
  0 => "205"
  1 => 3080
  2 => 4
]
select count(*) as aggregate from `product_comments` where `product_comments`.`ProductCommentsProductID` = ? and `product_comments`.`ProductCommentsProductID` is not null 0.48ms
array:1 [
  0 => 3081
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 1.1ms
array:3 [
  0 => "205"
  1 => 3081
  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 => 3815
]
select count(*) as aggregate from `products` where `products`.`ProductAtx` = ? and `products`.`ProductAtx` is not null and `ProductID` != ? and `ProductAtx` != ? 0.85ms
array:3 [
  0 => "285"
  1 => 3815
  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.6ms
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.57ms
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.49ms
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.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.52ms
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.51ms
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.57ms
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.52ms
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.56ms
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.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.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.52ms
array:2 [
  0 => 17
  1 => 2
]
select * from `banner_details` where `is_mobile` = ? and `banner_details`.`id` = ? limit 1 0.61ms
array:2 [
  0 => 0
  1 => 17
]
select * from `image` where `image`.`id` in (?) 0.49ms
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.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.57ms
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.47ms
array:1 [
  0 => 2
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.64ms
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.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.57ms
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.63ms
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.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 => 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.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.52ms
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.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.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.55ms
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.54ms
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.5ms
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.52ms
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.49ms
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.51ms
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.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.51ms
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.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.68ms
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.53ms
array:2 [
  0 => 20
  1 => 2
]
select * from `banner_positions` where `banner_positions`.`id` = ? limit 1 0.47ms
array:1 [
  0 => 6
]
select * from `banners_to_positions` where `banner_detail_id` != ? and `banners_to_positions`.`position_id` in (?) 0.52ms
array:2 [
  0 => 0
  1 => 6
]
select * from `product_pharmgroups` order by `pharmgroupName` asc 1.4ms
[]