SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001990s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007586s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034732 LIMIT 5 [ RunTime:0.001051s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034732 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034732 ORDER BY `unit` DESC [ RunTime:0.011745s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034732 LIMIT 2 [ RunTime:0.007310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034732 ORDER BY `minOrder` ASC [ RunTime:0.013514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276062 LIMIT 5 [ RunTime:0.045989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276062 ORDER BY `minOrder` ASC [ RunTime:0.053706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15276062 ORDER BY `unit` DESC [ RunTime:0.037757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15276062 LIMIT 2 [ RunTime:0.036750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276062 ORDER BY `minOrder` ASC [ RunTime:0.017072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034733 LIMIT 5 [ RunTime:0.014055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034733 ORDER BY `minOrder` ASC [ RunTime:0.048814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034733 ORDER BY `unit` DESC [ RunTime:0.049107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034733 LIMIT 2 [ RunTime:0.033826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034733 ORDER BY `minOrder` ASC [ RunTime:0.004220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037946 LIMIT 5 [ RunTime:0.016295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037946 ORDER BY `minOrder` ASC [ RunTime:0.040326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037946 ORDER BY `unit` DESC [ RunTime:0.028145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037946 LIMIT 2 [ RunTime:0.023173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037946 ORDER BY `minOrder` ASC [ RunTime:0.012715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037945 LIMIT 5 [ RunTime:0.022214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037945 ORDER BY `minOrder` ASC [ RunTime:0.020519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037945 ORDER BY `unit` DESC [ RunTime:0.018543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037945 LIMIT 2 [ RunTime:0.047742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037945 ORDER BY `minOrder` ASC [ RunTime:0.008677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037944 LIMIT 5 [ RunTime:0.022135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037944 ORDER BY `minOrder` ASC [ RunTime:0.018740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037944 ORDER BY `unit` DESC [ RunTime:0.071461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037944 LIMIT 2 [ RunTime:0.020459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037944 ORDER BY `minOrder` ASC [ RunTime:0.013888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17273331 LIMIT 5 [ RunTime:0.032920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17273331 ORDER BY `minOrder` ASC [ RunTime:0.016100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17273331 ORDER BY `unit` DESC [ RunTime:0.022658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17273331 LIMIT 2 [ RunTime:0.009627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17273331 ORDER BY `minOrder` ASC [ RunTime:0.012930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17273330 LIMIT 5 [ RunTime:0.041767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17273330 ORDER BY `minOrder` ASC [ RunTime:0.012300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17273330 ORDER BY `unit` DESC [ RunTime:0.002080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17273330 LIMIT 2 [ RunTime:0.017559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17273330 ORDER BY `minOrder` ASC [ RunTime:0.005582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276469 LIMIT 5 [ RunTime:0.024924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276469 ORDER BY `minOrder` ASC [ RunTime:0.025279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15276469 ORDER BY `unit` DESC [ RunTime:0.010753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15276469 LIMIT 2 [ RunTime:0.026672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276469 ORDER BY `minOrder` ASC [ RunTime:0.010424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276468 LIMIT 5 [ RunTime:0.024888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276468 ORDER BY `minOrder` ASC [ RunTime:0.028864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15276468 ORDER BY `unit` DESC [ RunTime:0.004596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15276468 LIMIT 2 [ RunTime:0.007253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276468 ORDER BY `minOrder` ASC [ RunTime:0.004142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12419666 LIMIT 5 [ RunTime:0.013652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12419666 ORDER BY `minOrder` ASC [ RunTime:0.003684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12419666 ORDER BY `unit` DESC [ RunTime:0.028446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12419666 LIMIT 2 [ RunTime:0.010265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12419666 ORDER BY `minOrder` ASC [ RunTime:0.005219s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32221380 LIMIT 5 [ RunTime:0.018132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221380 ORDER BY `minOrder` ASC [ RunTime:0.009979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32221380 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32221380 LIMIT 2 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221380 ORDER BY `minOrder` ASC [ RunTime:0.008202s ]
select * from pdf where partno='pbs-11327-b' and brandshort='bud industries' limit 1 [ RunTime:0.000508s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pbs-11327-b' OR `brand` LIKE 'bud industries%' ) ) LIMIT 1 [ RunTime:0.001673s ]
SELECT `id` FROM `stock` WHERE `id` <> 32221380 AND `partno` = 'pbs-11327-b' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.003038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037946 [ RunTime:0.008147s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63429116 LIMIT 5 [ RunTime:0.018811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63429116 ORDER BY `minOrder` ASC [ RunTime:0.006076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63429116 ORDER BY `unit` DESC [ RunTime:0.004205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63429116 LIMIT 2 [ RunTime:0.003522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63429116 ORDER BY `minOrder` ASC [ RunTime:0.004744s ]
select * from pdf where partno='PBS-11532-G' and brandshort='Bud Industries' limit 1 [ RunTime:0.000579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-11532-G' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.000356s ]
SELECT `id` FROM `stock` WHERE `id` <> 63429116 AND `partno` = 'PBS-11532-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.000958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034732 [ RunTime:0.007169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63428840 LIMIT 5 [ RunTime:0.001489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63428840 ORDER BY `minOrder` ASC [ RunTime:0.005706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63428840 ORDER BY `unit` DESC [ RunTime:0.003443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63428840 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63428840 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='PBS-11532-B' and brandshort='Bud Industries' limit 1 [ RunTime:0.001708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-11532-B' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.002706s ]
SELECT `id` FROM `stock` WHERE `id` <> 63428840 AND `partno` = 'PBS-11532-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.000591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034733 [ RunTime:0.002583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63433920 LIMIT 5 [ RunTime:0.007636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433920 ORDER BY `minOrder` ASC [ RunTime:0.006196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63433920 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63433920 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433920 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='PBS-11327-B' and brandshort='Bud Industries' limit 1 [ RunTime:0.000420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-11327-B' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.000549s ]
SELECT `id` FROM `stock` WHERE `id` <> 63433920 AND `partno` = 'PBS-11327-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037946 [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63433919 LIMIT 5 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433919 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63433919 ORDER BY `unit` DESC [ RunTime:0.000316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63433919 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433919 ORDER BY `minOrder` ASC [ RunTime:0.002590s ]
select * from pdf where partno='PBS-11294-G' and brandshort='Bud Industries' limit 1 [ RunTime:0.000458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-11294-G' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.000324s ]
SELECT `id` FROM `stock` WHERE `id` <> 63433919 AND `partno` = 'PBS-11294-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037945 [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63433918 LIMIT 5 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433918 ORDER BY `minOrder` ASC [ RunTime:0.009097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63433918 ORDER BY `unit` DESC [ RunTime:0.005939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63433918 LIMIT 2 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433918 ORDER BY `minOrder` ASC [ RunTime:0.003465s ]
select * from pdf where partno='PBS-11294-B' and brandshort='Bud Industries' limit 1 [ RunTime:0.001478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-11294-B' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.000594s ]
SELECT `id` FROM `stock` WHERE `id` <> 63433918 AND `partno` = 'PBS-11294-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037944 [ RunTime:0.002453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63429587 LIMIT 5 [ RunTime:0.010332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63429587 ORDER BY `minOrder` ASC [ RunTime:0.005530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63429587 ORDER BY `unit` DESC [ RunTime:0.000842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63429587 LIMIT 2 [ RunTime:0.005111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63429587 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='PBS-11327-G' and brandshort='Bud Industries' limit 1 [ RunTime:0.011275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-11327-G' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.005920s ]
SELECT `id` FROM `stock` WHERE `id` <> 63429587 AND `partno` = 'PBS-11327-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.006541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276062 [ RunTime:0.019084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43848582 LIMIT 5 [ RunTime:0.010569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43848582 ORDER BY `minOrder` ASC [ RunTime:0.022596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43848582 ORDER BY `unit` DESC [ RunTime:0.003287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43848582 LIMIT 2 [ RunTime:0.007818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43848582 ORDER BY `minOrder` ASC [ RunTime:0.002621s ]
select * from pdf where partno='PBS-12623ZG' and brandshort='Electroswitch' limit 1 [ RunTime:0.007710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-12623ZG' OR `brand` LIKE 'Electroswitch%' ) ) LIMIT 1 [ RunTime:0.005014s ]
SELECT `id` FROM `stock` WHERE `id` <> 43848582 AND `partno` = 'PBS-12623ZG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%electroswitch%' ) [ RunTime:0.010064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12419666 [ RunTime:0.009952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844943 LIMIT 5 [ RunTime:0.008996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844943 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844943 ORDER BY `unit` DESC [ RunTime:0.004196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844943 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844943 ORDER BY `minOrder` ASC [ RunTime:0.007978s ]
select * from pdf where partno='PBS-12631AB' and brandshort='Electroswitch' limit 1 [ RunTime:0.014963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-12631AB' OR `brand` LIKE 'Electroswitch%' ) ) LIMIT 1 [ RunTime:0.001339s ]
SELECT `id` FROM `stock` WHERE `id` <> 43844943 AND `partno` = 'PBS-12631AB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%electroswitch%' ) [ RunTime:0.004046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17273331 [ RunTime:0.010364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844942 LIMIT 5 [ RunTime:0.017675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844942 ORDER BY `minOrder` ASC [ RunTime:0.002763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844942 ORDER BY `unit` DESC [ RunTime:0.008070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844942 LIMIT 2 [ RunTime:0.012268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844942 ORDER BY `minOrder` ASC [ RunTime:0.004485s ]
select * from pdf where partno='PBS-12600CB' and brandshort='Electroswitch' limit 1 [ RunTime:0.018870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-12600CB' OR `brand` LIKE 'Electroswitch%' ) ) LIMIT 1 [ RunTime:0.027713s ]
SELECT `id` FROM `stock` WHERE `id` <> 43844942 AND `partno` = 'PBS-12600CB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%electroswitch%' ) [ RunTime:0.013206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17273330 [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32421448 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421448 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32421448 ORDER BY `unit` DESC [ RunTime:0.003442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32421448 LIMIT 2 [ RunTime:0.007456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421448 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='PBS-1' and brandshort='Omega' limit 1 [ RunTime:0.000770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PBS-1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002016s ]
SELECT `id` FROM `stock` WHERE `id` <> 32421448 AND `partno` = 'PBS-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.008767s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026521s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045967s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042858s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023682s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031317s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008838s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026234s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PBS-1%' OR `brand` LIKE 'PBS-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.048416s ]