SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001066s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051005s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516539 LIMIT 5 [ RunTime:0.077163s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.027430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516539 ORDER BY `minOrder` ASC [ RunTime:0.017012s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516539 ORDER BY `unit` DESC [ RunTime:0.036910s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516539 LIMIT 2 [ RunTime:0.031412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516539 ORDER BY `minOrder` ASC [ RunTime:0.040856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417193 LIMIT 5 [ RunTime:0.023470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417193 ORDER BY `minOrder` ASC [ RunTime:0.014598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417193 ORDER BY `unit` DESC [ RunTime:0.006913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417193 LIMIT 2 [ RunTime:0.022138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417193 ORDER BY `minOrder` ASC [ RunTime:0.015235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518846 LIMIT 5 [ RunTime:0.026858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518846 ORDER BY `minOrder` ASC [ RunTime:0.057286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12518846 ORDER BY `unit` DESC [ RunTime:0.029501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12518846 LIMIT 2 [ RunTime:0.081268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518846 ORDER BY `minOrder` ASC [ RunTime:0.023479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517826 LIMIT 5 [ RunTime:0.056438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517826 ORDER BY `minOrder` ASC [ RunTime:0.057171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517826 ORDER BY `unit` DESC [ RunTime:0.018081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517826 LIMIT 2 [ RunTime:0.057002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517826 ORDER BY `minOrder` ASC [ RunTime:0.055675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517586 LIMIT 5 [ RunTime:0.013100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517586 ORDER BY `minOrder` ASC [ RunTime:0.029258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517586 ORDER BY `unit` DESC [ RunTime:0.025887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517586 LIMIT 2 [ RunTime:0.006633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517586 ORDER BY `minOrder` ASC [ RunTime:0.007626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517489 LIMIT 5 [ RunTime:0.011271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517489 ORDER BY `minOrder` ASC [ RunTime:0.003252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517489 ORDER BY `unit` DESC [ RunTime:0.001424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517489 LIMIT 2 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517489 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166164 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12166164 ORDER BY `minOrder` ASC [ RunTime:0.003807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12166164 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12166164 LIMIT 2 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12166164 ORDER BY `minOrder` ASC [ RunTime:0.007410s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010906s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60641131 LIMIT 5 [ RunTime:0.010553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641131 ORDER BY `minOrder` ASC [ RunTime:0.010012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60641131 ORDER BY `unit` DESC [ RunTime:0.001344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60641131 LIMIT 2 [ RunTime:0.004591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641131 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='336075-5' and brandshort='TE Connectivity' limit 1 [ RunTime:0.008143s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336075-5' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.032968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639930 LIMIT 5 [ RunTime:0.005764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639930 ORDER BY `minOrder` ASC [ RunTime:0.026386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639930 ORDER BY `unit` DESC [ RunTime:0.022660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639930 LIMIT 2 [ RunTime:0.013378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639930 ORDER BY `minOrder` ASC [ RunTime:0.014528s ]
select * from pdf where partno='336075-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336075-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.036675s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639930 AND `partno` = '336075-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.026643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516539 [ RunTime:0.023062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60641135 LIMIT 5 [ RunTime:0.029187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641135 ORDER BY `minOrder` ASC [ RunTime:0.038572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60641135 ORDER BY `unit` DESC [ RunTime:0.003000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60641135 LIMIT 2 [ RunTime:0.002583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641135 ORDER BY `minOrder` ASC [ RunTime:0.007261s ]
select * from pdf where partno='336075-3' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336075-3' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.017094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60642275 LIMIT 5 [ RunTime:0.020687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60642275 ORDER BY `minOrder` ASC [ RunTime:0.036970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60642275 ORDER BY `unit` DESC [ RunTime:0.012268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60642275 LIMIT 2 [ RunTime:0.007895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60642275 ORDER BY `minOrder` ASC [ RunTime:0.001598s ]
select * from pdf where partno='336074-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336074-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001741s ]
SELECT `id` FROM `stock` WHERE `id` <> 60642275 AND `partno` = '336074-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517586 [ RunTime:0.021127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60641938 LIMIT 5 [ RunTime:0.008112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641938 ORDER BY `minOrder` ASC [ RunTime:0.004988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60641938 ORDER BY `unit` DESC [ RunTime:0.018043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60641938 LIMIT 2 [ RunTime:0.007784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641938 ORDER BY `minOrder` ASC [ RunTime:0.005981s ]
select * from pdf where partno='336076-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336076-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011928s ]
SELECT `id` FROM `stock` WHERE `id` <> 60641938 AND `partno` = '336076-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517489 [ RunTime:0.010893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639934 LIMIT 5 [ RunTime:0.001539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639934 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639934 ORDER BY `unit` DESC [ RunTime:0.012342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639934 LIMIT 2 [ RunTime:0.006458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639934 ORDER BY `minOrder` ASC [ RunTime:0.006158s ]
select * from pdf where partno='336076-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336076-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008357s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639934 AND `partno` = '336076-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417193 [ RunTime:0.000731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58564476 LIMIT 5 [ RunTime:0.004870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58564476 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58564476 ORDER BY `unit` DESC [ RunTime:0.006720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58564476 LIMIT 2 [ RunTime:0.003614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58564476 ORDER BY `minOrder` ASC [ RunTime:0.005189s ]
select * from pdf where partno='33607' and brandshort='Wiha' limit 1 [ RunTime:0.000537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33607' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.003240s ]
SELECT `id` FROM `stock` WHERE `id` <> 58564476 AND `partno` = '33607' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.004968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166164 [ RunTime:0.000786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32499046 LIMIT 5 [ RunTime:0.011862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32499046 ORDER BY `minOrder` ASC [ RunTime:0.024316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32499046 ORDER BY `unit` DESC [ RunTime:0.033960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32499046 LIMIT 2 [ RunTime:0.033916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32499046 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
select * from pdf where partno='336072' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.032910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336072' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.011736s ]
SELECT `id` FROM `stock` WHERE `id` <> 32499046 AND `partno` = '336072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.052090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32444317 LIMIT 5 [ RunTime:0.012526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32444317 ORDER BY `minOrder` ASC [ RunTime:0.047109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32444317 ORDER BY `unit` DESC [ RunTime:0.015115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32444317 LIMIT 2 [ RunTime:0.040792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32444317 ORDER BY `minOrder` ASC [ RunTime:0.003974s ]
select * from pdf where partno='336077' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.005466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336077' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.034817s ]
SELECT `id` FROM `stock` WHERE `id` <> 32444317 AND `partno` = '336077' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.038099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32411721 LIMIT 5 [ RunTime:0.018301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32411721 ORDER BY `minOrder` ASC [ RunTime:0.018127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32411721 ORDER BY `unit` DESC [ RunTime:0.001931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32411721 LIMIT 2 [ RunTime:0.013306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32411721 ORDER BY `minOrder` ASC [ RunTime:0.003617s ]
select * from pdf where partno='336070' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.001926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '336070' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.014198s ]
SELECT `id` FROM `stock` WHERE `id` <> 32411721 AND `partno` = '336070' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.011584s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011096s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007891s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022188s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017406s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029308s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003582s ]
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 '33607%' OR `brand` LIKE '33607%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002359s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '33607%' OR `brand` LIKE '33607%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024894s ]