SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002464s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029508s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12676079 LIMIT 5 [ RunTime:0.013818s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12676079 ORDER BY `minOrder` ASC [ RunTime:0.006743s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12676079 ORDER BY `unit` DESC [ RunTime:0.008977s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12676079 LIMIT 2 [ RunTime:0.027375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12676079 ORDER BY `minOrder` ASC [ RunTime:0.007599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12698861 LIMIT 5 [ RunTime:0.028319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12698861 ORDER BY `minOrder` ASC [ RunTime:0.004970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12698861 ORDER BY `unit` DESC [ RunTime:0.010163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12698861 LIMIT 2 [ RunTime:0.014546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12698861 ORDER BY `minOrder` ASC [ RunTime:0.005236s ]
select * from pdf where partno='SSM-116-L-DV-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694521 LIMIT 5 [ RunTime:0.007185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694521 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12694521 ORDER BY `unit` DESC [ RunTime:0.009029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12694521 LIMIT 2 [ RunTime:0.010272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694521 ORDER BY `minOrder` ASC [ RunTime:0.000763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694097 LIMIT 5 [ RunTime:0.004549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694097 ORDER BY `minOrder` ASC [ RunTime:0.022628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12694097 ORDER BY `unit` DESC [ RunTime:0.016200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12694097 LIMIT 2 [ RunTime:0.027206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694097 ORDER BY `minOrder` ASC [ RunTime:0.015317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694080 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694080 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12694080 ORDER BY `unit` DESC [ RunTime:0.003543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12694080 LIMIT 2 [ RunTime:0.004031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694080 ORDER BY `minOrder` ASC [ RunTime:0.016955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693946 LIMIT 5 [ RunTime:0.014729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693946 ORDER BY `minOrder` ASC [ RunTime:0.004794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12693946 ORDER BY `unit` DESC [ RunTime:0.002351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12693946 LIMIT 2 [ RunTime:0.007226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693946 ORDER BY `minOrder` ASC [ RunTime:0.003075s ]
select * from pdf where partno='SSM-116-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693932 LIMIT 5 [ RunTime:0.008857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693932 ORDER BY `minOrder` ASC [ RunTime:0.032052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12693932 ORDER BY `unit` DESC [ RunTime:0.015773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12693932 LIMIT 2 [ RunTime:0.003014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693932 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693931 LIMIT 5 [ RunTime:0.007083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693931 ORDER BY `minOrder` ASC [ RunTime:0.006358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12693931 ORDER BY `unit` DESC [ RunTime:0.011559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12693931 LIMIT 2 [ RunTime:0.005044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693931 ORDER BY `minOrder` ASC [ RunTime:0.001259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12692463 LIMIT 5 [ RunTime:0.013811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692463 ORDER BY `minOrder` ASC [ RunTime:0.011332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12692463 ORDER BY `unit` DESC [ RunTime:0.012692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12692463 LIMIT 2 [ RunTime:0.002861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692463 ORDER BY `minOrder` ASC [ RunTime:0.003728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12692352 LIMIT 5 [ RunTime:0.003149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692352 ORDER BY `minOrder` ASC [ RunTime:0.000752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12692352 ORDER BY `unit` DESC [ RunTime:0.001222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12692352 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692352 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663728 LIMIT 5 [ RunTime:0.001134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663728 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12663728 ORDER BY `unit` DESC [ RunTime:0.003679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12663728 LIMIT 2 [ RunTime:0.016288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663728 ORDER BY `minOrder` ASC [ RunTime:0.009146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663719 LIMIT 5 [ RunTime:0.002488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663719 ORDER BY `minOrder` ASC [ RunTime:0.005802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12663719 ORDER BY `unit` DESC [ RunTime:0.005999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12663719 LIMIT 2 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663719 ORDER BY `minOrder` ASC [ RunTime:0.001053s ]
select * from pdf where partno='SSM-116-L-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662377 LIMIT 5 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662377 ORDER BY `minOrder` ASC [ RunTime:0.031832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12662377 ORDER BY `unit` DESC [ RunTime:0.011604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12662377 LIMIT 2 [ RunTime:0.021568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662377 ORDER BY `minOrder` ASC [ RunTime:0.003963s ]
select * from pdf where partno='SSM-116-L-DV-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662261 LIMIT 5 [ RunTime:0.023345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662261 ORDER BY `minOrder` ASC [ RunTime:0.013042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12662261 ORDER BY `unit` DESC [ RunTime:0.023386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12662261 LIMIT 2 [ RunTime:0.007852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662261 ORDER BY `minOrder` ASC [ RunTime:0.001537s ]
select * from pdf where partno='SSM-116-L-DV-BE-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662186 LIMIT 5 [ RunTime:0.013957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662186 ORDER BY `minOrder` ASC [ RunTime:0.016018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12662186 ORDER BY `unit` DESC [ RunTime:0.023124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12662186 LIMIT 2 [ RunTime:0.002580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662186 ORDER BY `minOrder` ASC [ RunTime:0.006790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11545867 LIMIT 5 [ RunTime:0.001239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11545867 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11545867 ORDER BY `unit` DESC [ RunTime:0.000199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11545867 LIMIT 2 [ RunTime:0.000188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11545867 ORDER BY `minOrder` ASC [ RunTime:0.002082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11542837 LIMIT 5 [ RunTime:0.002109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11542837 ORDER BY `minOrder` ASC [ RunTime:0.005430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11542837 ORDER BY `unit` DESC [ RunTime:0.014689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11542837 LIMIT 2 [ RunTime:0.002307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11542837 ORDER BY `minOrder` ASC [ RunTime:0.009651s ]
select * from pdf where partno='SSM-116-L-DV-BE-A-M' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11542836 LIMIT 5 [ RunTime:0.002592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11542836 ORDER BY `minOrder` ASC [ RunTime:0.001526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11542836 ORDER BY `unit` DESC [ RunTime:0.002814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11542836 LIMIT 2 [ RunTime:0.002733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11542836 ORDER BY `minOrder` ASC [ RunTime:0.005957s ]
select * from pdf where partno='SSM-116-L-DV-A-M' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11542777 LIMIT 5 [ RunTime:0.003134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11542777 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11542777 ORDER BY `unit` DESC [ RunTime:0.000204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11542777 LIMIT 2 [ RunTime:0.000213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11542777 ORDER BY `minOrder` ASC [ RunTime:0.001600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11539112 LIMIT 5 [ RunTime:0.003598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11539112 ORDER BY `minOrder` ASC [ RunTime:0.002871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11539112 ORDER BY `unit` DESC [ RunTime:0.021714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11539112 LIMIT 2 [ RunTime:0.011481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11539112 ORDER BY `minOrder` ASC [ RunTime:0.010216s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014743s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59755925 LIMIT 5 [ RunTime:0.001970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59755925 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59755925 ORDER BY `unit` DESC [ RunTime:0.003170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59755925 LIMIT 2 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59755925 ORDER BY `minOrder` ASC [ RunTime:0.002735s ]
select * from pdf where partno='SSM-116-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001854s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000319s ]
SELECT `id` FROM `stock` WHERE `id` <> 59755925 AND `partno` = 'SSM-116-L-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753347 LIMIT 5 [ RunTime:0.004256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753347 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753347 ORDER BY `unit` DESC [ RunTime:0.000796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753347 LIMIT 2 [ RunTime:0.002945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753347 ORDER BY `minOrder` ASC [ RunTime:0.005345s ]
select * from pdf where partno='SSM-116-L-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020194s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753347 AND `partno` = 'SSM-116-L-DV-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533280 [ RunTime:0.002508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59754998 LIMIT 5 [ RunTime:0.006083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59754998 ORDER BY `minOrder` ASC [ RunTime:0.022236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59754998 ORDER BY `unit` DESC [ RunTime:0.003307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59754998 LIMIT 2 [ RunTime:0.016885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59754998 ORDER BY `minOrder` ASC [ RunTime:0.009461s ]
select * from pdf where partno='SSM-116-L-DV-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001513s ]
SELECT `id` FROM `stock` WHERE `id` <> 59754998 AND `partno` = 'SSM-116-L-DV-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12676079 [ RunTime:0.007668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59784246 LIMIT 5 [ RunTime:0.002621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59784246 ORDER BY `minOrder` ASC [ RunTime:0.007333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59784246 ORDER BY `unit` DESC [ RunTime:0.004337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59784246 LIMIT 2 [ RunTime:0.005088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59784246 ORDER BY `minOrder` ASC [ RunTime:0.002052s ]
select * from pdf where partno='SSM-116-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000523s ]
SELECT `id` FROM `stock` WHERE `id` <> 59784246 AND `partno` = 'SSM-116-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59840253 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840253 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59840253 ORDER BY `unit` DESC [ RunTime:0.004017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59840253 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840253 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='SSM-116-L-DV-A-004' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A-004' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004053s ]
SELECT `id` FROM `stock` WHERE `id` <> 59840253 AND `partno` = 'SSM-116-L-DV-A-004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11545867 [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59835912 LIMIT 5 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835912 ORDER BY `minOrder` ASC [ RunTime:0.004723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59835912 ORDER BY `unit` DESC [ RunTime:0.005353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59835912 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835912 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='SSM-116-L-DV-BE-A-M' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-BE-A-M' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016040s ]
SELECT `id` FROM `stock` WHERE `id` <> 59835912 AND `partno` = 'SSM-116-L-DV-BE-A-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11542837 [ RunTime:0.022351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59835911 LIMIT 5 [ RunTime:0.006359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835911 ORDER BY `minOrder` ASC [ RunTime:0.006875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59835911 ORDER BY `unit` DESC [ RunTime:0.002530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59835911 LIMIT 2 [ RunTime:0.005927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835911 ORDER BY `minOrder` ASC [ RunTime:0.005530s ]
select * from pdf where partno='SSM-116-L-DV-A-M' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A-M' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000529s ]
SELECT `id` FROM `stock` WHERE `id` <> 59835911 AND `partno` = 'SSM-116-L-DV-A-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11542836 [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59835653 LIMIT 5 [ RunTime:0.012330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835653 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59835653 ORDER BY `unit` DESC [ RunTime:0.001400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59835653 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835653 ORDER BY `minOrder` ASC [ RunTime:0.001398s ]
select * from pdf where partno='SSM-116-L-DV-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 59835653 AND `partno` = 'SSM-116-L-DV-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11542777 [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59834227 LIMIT 5 [ RunTime:0.003330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59834227 ORDER BY `minOrder` ASC [ RunTime:0.001182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59834227 ORDER BY `unit` DESC [ RunTime:0.009010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59834227 LIMIT 2 [ RunTime:0.006540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59834227 ORDER BY `minOrder` ASC [ RunTime:0.004043s ]
select * from pdf where partno='SSM-116-L-DV-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003541s ]
SELECT `id` FROM `stock` WHERE `id` <> 59834227 AND `partno` = 'SSM-116-L-DV-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12698861 [ RunTime:0.005693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59831934 LIMIT 5 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831934 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59831934 ORDER BY `unit` DESC [ RunTime:0.000468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59831934 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831934 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='SSM-116-L-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001602s ]
SELECT `id` FROM `stock` WHERE `id` <> 59831934 AND `partno` = 'SSM-116-L-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694521 [ RunTime:0.000405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59831887 LIMIT 5 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831887 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59831887 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59831887 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831887 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='SSM-116-L-DV-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000407s ]
SELECT `id` FROM `stock` WHERE `id` <> 59831887 AND `partno` = 'SSM-116-L-DV-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59831222 LIMIT 5 [ RunTime:0.003012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831222 ORDER BY `minOrder` ASC [ RunTime:0.007506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59831222 ORDER BY `unit` DESC [ RunTime:0.000822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59831222 LIMIT 2 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831222 ORDER BY `minOrder` ASC [ RunTime:0.001691s ]
select * from pdf where partno='SSM-116-L-DV-LC-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-LC-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004090s ]
SELECT `id` FROM `stock` WHERE `id` <> 59831222 AND `partno` = 'SSM-116-L-DV-LC-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11539112 [ RunTime:0.010057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59831221 LIMIT 5 [ RunTime:0.009271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831221 ORDER BY `minOrder` ASC [ RunTime:0.006019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59831221 ORDER BY `unit` DESC [ RunTime:0.011477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59831221 LIMIT 2 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831221 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='SSM-116-L-DV-BE-A-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-BE-A-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005628s ]
SELECT `id` FROM `stock` WHERE `id` <> 59831221 AND `partno` = 'SSM-116-L-DV-BE-A-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11539111 [ RunTime:0.011399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59831220 LIMIT 5 [ RunTime:0.006514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831220 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59831220 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59831220 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831220 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='SSM-116-L-DV-A-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000439s ]
SELECT `id` FROM `stock` WHERE `id` <> 59831220 AND `partno` = 'SSM-116-L-DV-A-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694080 [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59831219 LIMIT 5 [ RunTime:0.002115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831219 ORDER BY `minOrder` ASC [ RunTime:0.003348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59831219 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59831219 LIMIT 2 [ RunTime:0.002778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831219 ORDER BY `minOrder` ASC [ RunTime:0.004622s ]
select * from pdf where partno='SSM-116-L-DV-BE-LC-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-BE-LC-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004454s ]
SELECT `id` FROM `stock` WHERE `id` <> 59831219 AND `partno` = 'SSM-116-L-DV-BE-LC-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694097 [ RunTime:0.005374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59830910 LIMIT 5 [ RunTime:0.008169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830910 ORDER BY `minOrder` ASC [ RunTime:0.001367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59830910 ORDER BY `unit` DESC [ RunTime:0.000959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59830910 LIMIT 2 [ RunTime:0.000777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830910 ORDER BY `minOrder` ASC [ RunTime:0.003267s ]
select * from pdf where partno='SSM-116-L-DV-BE-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-BE-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001186s ]
SELECT `id` FROM `stock` WHERE `id` <> 59830910 AND `partno` = 'SSM-116-L-DV-BE-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693931 [ RunTime:0.004304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59830905 LIMIT 5 [ RunTime:0.002728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830905 ORDER BY `minOrder` ASC [ RunTime:0.000839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59830905 ORDER BY `unit` DESC [ RunTime:0.000729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59830905 LIMIT 2 [ RunTime:0.009018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830905 ORDER BY `minOrder` ASC [ RunTime:0.007630s ]
select * from pdf where partno='SSM-116-L-DV-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003574s ]
SELECT `id` FROM `stock` WHERE `id` <> 59830905 AND `partno` = 'SSM-116-L-DV-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693932 [ RunTime:0.012311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59830884 LIMIT 5 [ RunTime:0.002126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830884 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59830884 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59830884 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830884 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='SSM-116-L-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000326s ]
SELECT `id` FROM `stock` WHERE `id` <> 59830884 AND `partno` = 'SSM-116-L-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693946 [ RunTime:0.000321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59829633 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59829633 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59829633 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59829633 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59829633 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='SSM-116-L-DV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000335s ]
SELECT `id` FROM `stock` WHERE `id` <> 59829633 AND `partno` = 'SSM-116-L-DV-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538571 [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59829125 LIMIT 5 [ RunTime:0.001636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59829125 ORDER BY `minOrder` ASC [ RunTime:0.008776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59829125 ORDER BY `unit` DESC [ RunTime:0.002669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59829125 LIMIT 2 [ RunTime:0.006403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59829125 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
select * from pdf where partno='SSM-116-L-DV-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-116-L-DV-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003464s ]
SELECT `id` FROM `stock` WHERE `id` <> 59829125 AND `partno` = 'SSM-116-L-DV-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538351 [ RunTime:0.000801s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000962s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006929s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004398s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004854s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003871s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000776s ]
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 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000644s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SSM-116-L-DV%' OR `brand` LIKE 'SSM-116-L-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006447s ]