SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002427s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003842s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089099 LIMIT 5 [ RunTime:0.003176s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16089099 ORDER BY `minOrder` ASC [ RunTime:0.007529s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16089099 ORDER BY `unit` DESC [ RunTime:0.003653s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16089099 LIMIT 2 [ RunTime:0.005002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16089099 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089078 LIMIT 5 [ RunTime:0.013572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16089078 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16089078 ORDER BY `unit` DESC [ RunTime:0.016407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16089078 LIMIT 2 [ RunTime:0.008206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16089078 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19173858 LIMIT 5 [ RunTime:0.001772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173858 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19173858 ORDER BY `unit` DESC [ RunTime:0.012081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19173858 LIMIT 2 [ RunTime:0.001628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173858 ORDER BY `minOrder` ASC [ RunTime:0.002013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089100 LIMIT 5 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16089100 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16089100 ORDER BY `unit` DESC [ RunTime:0.010201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16089100 LIMIT 2 [ RunTime:0.001576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16089100 ORDER BY `minOrder` ASC [ RunTime:0.002087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19172275 LIMIT 5 [ RunTime:0.002372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19172275 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19172275 ORDER BY `unit` DESC [ RunTime:0.010862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19172275 LIMIT 2 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19172275 ORDER BY `minOrder` ASC [ RunTime:0.002540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19173168 LIMIT 5 [ RunTime:0.003178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173168 ORDER BY `minOrder` ASC [ RunTime:0.000822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19173168 ORDER BY `unit` DESC [ RunTime:0.008614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19173168 LIMIT 2 [ RunTime:0.004404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173168 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19173101 LIMIT 5 [ RunTime:0.002455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173101 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19173101 ORDER BY `unit` DESC [ RunTime:0.010658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19173101 LIMIT 2 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173101 ORDER BY `minOrder` ASC [ RunTime:0.002492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15324612 LIMIT 5 [ RunTime:0.003054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15324612 ORDER BY `minOrder` ASC [ RunTime:0.002706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15324612 ORDER BY `unit` DESC [ RunTime:0.008132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15324612 LIMIT 2 [ RunTime:0.006516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15324612 ORDER BY `minOrder` ASC [ RunTime:0.002679s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001693s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50128491 LIMIT 5 [ RunTime:0.001404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128491 ORDER BY `minOrder` ASC [ RunTime:0.003694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50128491 ORDER BY `unit` DESC [ RunTime:0.010304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50128491 LIMIT 2 [ RunTime:0.004506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128491 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='CS82C37AB6009' and brandshort='Harris Corporation' limit 1 [ RunTime:0.001909s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37AB6009' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.003137s ]
SELECT `id` FROM `stock` WHERE `id` <> 50128491 AND `partno` = 'CS82C37AB6009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.001285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089099 [ RunTime:0.001270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37325550 LIMIT 5 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325550 ORDER BY `minOrder` ASC [ RunTime:0.001800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37325550 ORDER BY `unit` DESC [ RunTime:0.005074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37325550 LIMIT 2 [ RunTime:0.001308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325550 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='CS82C37AB6009' and brandshort='Harris Corporation' limit 1 [ RunTime:0.000474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37AB6009' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.000336s ]
SELECT `id` FROM `stock` WHERE `id` <> 37325550 AND `partno` = 'CS82C37AB6009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.000619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089099 [ RunTime:0.001381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50128406 LIMIT 5 [ RunTime:0.002053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128406 ORDER BY `minOrder` ASC [ RunTime:0.002430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50128406 ORDER BY `unit` DESC [ RunTime:0.004855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50128406 LIMIT 2 [ RunTime:0.001441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128406 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='CS82C37A-5' and brandshort='Harris Corporation' limit 1 [ RunTime:0.001271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37A-5' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.007997s ]
SELECT `id` FROM `stock` WHERE `id` <> 50128406 AND `partno` = 'CS82C37A-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.004801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089078 [ RunTime:0.002023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37325466 LIMIT 5 [ RunTime:0.005958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325466 ORDER BY `minOrder` ASC [ RunTime:0.002620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37325466 ORDER BY `unit` DESC [ RunTime:0.010605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37325466 LIMIT 2 [ RunTime:0.002692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325466 ORDER BY `minOrder` ASC [ RunTime:0.001284s ]
select * from pdf where partno='CS82C37A-5' and brandshort='Harris Corporation' limit 1 [ RunTime:0.000433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37A-5' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.000328s ]
SELECT `id` FROM `stock` WHERE `id` <> 37325466 AND `partno` = 'CS82C37A-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.000783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089078 [ RunTime:0.002119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50128407 LIMIT 5 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128407 ORDER BY `minOrder` ASC [ RunTime:0.001850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50128407 ORDER BY `unit` DESC [ RunTime:0.006414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50128407 LIMIT 2 [ RunTime:0.003075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128407 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='CS82C37A-596' and brandshort='Harris Corporation' limit 1 [ RunTime:0.001677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37A-596' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.002870s ]
SELECT `id` FROM `stock` WHERE `id` <> 50128407 AND `partno` = 'CS82C37A-596' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.003243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19173858 [ RunTime:0.001047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37325467 LIMIT 5 [ RunTime:0.006649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325467 ORDER BY `minOrder` ASC [ RunTime:0.001812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37325467 ORDER BY `unit` DESC [ RunTime:0.006004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37325467 LIMIT 2 [ RunTime:0.002092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325467 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
select * from pdf where partno='CS82C37A-596' and brandshort='Harris Corporation' limit 1 [ RunTime:0.000765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37A-596' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.000425s ]
SELECT `id` FROM `stock` WHERE `id` <> 37325467 AND `partno` = 'CS82C37A-596' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.000876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19173858 [ RunTime:0.001238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50128492 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128492 ORDER BY `minOrder` ASC [ RunTime:0.001288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50128492 ORDER BY `unit` DESC [ RunTime:0.007084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50128492 LIMIT 2 [ RunTime:0.001848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128492 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
select * from pdf where partno='CS82C37AS2455' and brandshort='Harris Corporation' limit 1 [ RunTime:0.001078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37AS2455' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.002632s ]
SELECT `id` FROM `stock` WHERE `id` <> 50128492 AND `partno` = 'CS82C37AS2455' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.001826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089100 [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37325551 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325551 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37325551 ORDER BY `unit` DESC [ RunTime:0.002611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37325551 LIMIT 2 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325551 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='CS82C37AS2455' and brandshort='Harris Corporation' limit 1 [ RunTime:0.000901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37AS2455' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.000417s ]
SELECT `id` FROM `stock` WHERE `id` <> 37325551 AND `partno` = 'CS82C37AS2455' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.000830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089100 [ RunTime:0.001530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50128809 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128809 ORDER BY `minOrder` ASC [ RunTime:0.001252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50128809 ORDER BY `unit` DESC [ RunTime:0.007430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50128809 LIMIT 2 [ RunTime:0.002370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50128809 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
select * from pdf where partno='CS82C37A' and brandshort='Harris Corporation' limit 1 [ RunTime:0.001566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37A' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.000762s ]
SELECT `id` FROM `stock` WHERE `id` <> 50128809 AND `partno` = 'CS82C37A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.002444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19172275 [ RunTime:0.000786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37325875 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325875 ORDER BY `minOrder` ASC [ RunTime:0.002551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37325875 ORDER BY `unit` DESC [ RunTime:0.002685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37325875 LIMIT 2 [ RunTime:0.001962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37325875 ORDER BY `minOrder` ASC [ RunTime:0.000808s ]
select * from pdf where partno='CS82C37A' and brandshort='Harris Corporation' limit 1 [ RunTime:0.000861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CS82C37A' OR `brand` LIKE 'Harris Corporation%' ) ) LIMIT 1 [ RunTime:0.000426s ]
SELECT `id` FROM `stock` WHERE `id` <> 37325875 AND `partno` = 'CS82C37A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harris corporation%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19172275 [ RunTime:0.001794s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001287s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002499s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003027s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001178s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001154s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001147s ]
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 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001678s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CS82C37A%' OR `brand` LIKE 'CS82C37A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001675s ]