Advertisement
Guest User

вапр

a guest
Jan 26th, 2015
230
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.13 KB | None | 0 0
  1. InvoicePosition Load (0.3ms) SELECT `invoice_positions`.* FROM `invoice_positions` WHERE `invoice_positions`.`invoice_id` = 6020402
  2. Pharmacy Load (0.2ms) SELECT `pharmacies`.* FROM `pharmacies` WHERE `pharmacies`.`id` = 306 LIMIT 1
  3. PriceList Load (0.1ms) SELECT `price_lists`.* FROM `price_lists` WHERE `price_lists`.`id` = 243 LIMIT 1
  4. PromotionPosition Load (0.2ms) SELECT `promotion_positions`.* FROM `promotion_positions` INNER JOIN promotions ON promotions.id = promotion_positions.promotion_id
  5. LEFT JOIN pharmacies_promotions ON pharmacies_promotions.promotion_id = promotions.id WHERE `promotion_positions`.`product_id` IN (9996516, 3771153, 3798076, 3753798, 3754666, 3754925, 3771226, 3771655, 3750700, 3775302, 3789592) AND (`promotion_positions`.`fixed_selling_price` IS NOT NULL AND
  6. `promotion_positions`.`fixed_selling_price` != '' AND
  7. `promotions`.`is_have_fixed_selling_price` IS TRUE AND
  8. `promotions`.`is_active` IS TRUE AND
  9. (`promotions`.`is_available_for_all_pharmacies` IS TRUE OR `pharmacies_promotions`.`pharmacy_id` = 306)) ORDER BY `promotion_positions`.`product_id`, `promotion_positions`.`updated_at` DESC
  10. Product Load (0.2ms) SELECT `products`.* FROM `products` WHERE `products`.`id` = 9996516 LIMIT 1
  11. (0.2ms) ROLLBACK
  12. PharmacyChain Load (0.4ms) SELECT `pharmacy_chains`.* FROM `pharmacy_chains` INNER JOIN `pharmacies` ON `pharmacy_chains`.`id` = `pharmacies`.`pharmacy_chain_id` WHERE `pharmacies`.`id` = 306 LIMIT 1
  13. InvoicePosition Load (0.3ms) SELECT `invoice_positions`.* FROM `invoice_positions` WHERE `invoice_positions`.`invoice_id` = 6020402
  14. ProductBarcode Load (0.2ms) SELECT `product_barcodes`.* FROM `product_barcodes` WHERE `product_barcodes`.`barcode` IN ('4607009582290', '9993671002258', '4660010100013', '4601026302619', '4022536645612', '4008617149774', '5997001357781', '4607159860422', '4607011664663', '8699525094681', '4601372001686') AND `product_barcodes`.`product_id` IN (9996516, 3771153, 3798076, 3753798, 3754666, 3754925, 3771226, 3771655, 3750700, 3775302, 3789592) ORDER BY `product_barcodes`.`id` ASC LIMIT 5000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement