SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003267s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037390s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674430 LIMIT 5 [ RunTime:0.030358s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674430 ORDER BY `minOrder` ASC [ RunTime:0.031382s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11674430 ORDER BY `unit` DESC [ RunTime:0.019237s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11674430 LIMIT 2 [ RunTime:0.011765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674430 ORDER BY `minOrder` ASC [ RunTime:0.016753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12869069 LIMIT 5 [ RunTime:0.012650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12869069 ORDER BY `minOrder` ASC [ RunTime:0.052446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12869069 ORDER BY `unit` DESC [ RunTime:0.017248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12869069 LIMIT 2 [ RunTime:0.010455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12869069 ORDER BY `minOrder` ASC [ RunTime:0.034481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14689034 LIMIT 5 [ RunTime:0.017840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14689034 ORDER BY `minOrder` ASC [ RunTime:0.015522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14689034 ORDER BY `unit` DESC [ RunTime:0.021534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14689034 LIMIT 2 [ RunTime:0.039345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14689034 ORDER BY `minOrder` ASC [ RunTime:0.063637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14672773 LIMIT 5 [ RunTime:0.057176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14672773 ORDER BY `minOrder` ASC [ RunTime:0.030838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14672773 ORDER BY `unit` DESC [ RunTime:0.047804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14672773 LIMIT 2 [ RunTime:0.047090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14672773 ORDER BY `minOrder` ASC [ RunTime:0.011868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19659982 LIMIT 5 [ RunTime:0.025931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659982 ORDER BY `minOrder` ASC [ RunTime:0.038747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19659982 ORDER BY `unit` DESC [ RunTime:0.030734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19659982 LIMIT 2 [ RunTime:0.022151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659982 ORDER BY `minOrder` ASC [ RunTime:0.044285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264637 LIMIT 5 [ RunTime:0.027916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264637 ORDER BY `minOrder` ASC [ RunTime:0.014283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264637 ORDER BY `unit` DESC [ RunTime:0.034731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264637 LIMIT 2 [ RunTime:0.015791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264637 ORDER BY `minOrder` ASC [ RunTime:0.006483s ]
select * from pdf where partno='151805' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17502283 LIMIT 5 [ RunTime:0.022254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502283 ORDER BY `minOrder` ASC [ RunTime:0.003527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17502283 ORDER BY `unit` DESC [ RunTime:0.001010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17502283 LIMIT 2 [ RunTime:0.001633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502283 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17500084 LIMIT 5 [ RunTime:0.009428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17500084 ORDER BY `minOrder` ASC [ RunTime:0.017830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17500084 ORDER BY `unit` DESC [ RunTime:0.000788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17500084 LIMIT 2 [ RunTime:0.001650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17500084 ORDER BY `minOrder` ASC [ RunTime:0.003925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17496943 LIMIT 5 [ RunTime:0.013028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17496943 ORDER BY `minOrder` ASC [ RunTime:0.005086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17496943 ORDER BY `unit` DESC [ RunTime:0.003167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17496943 LIMIT 2 [ RunTime:0.028784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17496943 ORDER BY `minOrder` ASC [ RunTime:0.005479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17491251 LIMIT 5 [ RunTime:0.011195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491251 ORDER BY `minOrder` ASC [ RunTime:0.040993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17491251 ORDER BY `unit` DESC [ RunTime:0.009980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17491251 LIMIT 2 [ RunTime:0.001778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491251 ORDER BY `minOrder` ASC [ RunTime:0.001332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17485585 LIMIT 5 [ RunTime:0.004191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17485585 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17485585 ORDER BY `unit` DESC [ RunTime:0.010327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17485585 LIMIT 2 [ RunTime:0.012952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17485585 ORDER BY `minOrder` ASC [ RunTime:0.004372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16615351 LIMIT 5 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615351 ORDER BY `minOrder` ASC [ RunTime:0.000854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16615351 ORDER BY `unit` DESC [ RunTime:0.000870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16615351 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615351 ORDER BY `minOrder` ASC [ RunTime:0.001487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15378726 LIMIT 5 [ RunTime:0.005333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15378726 ORDER BY `minOrder` ASC [ RunTime:0.017690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15378726 ORDER BY `unit` DESC [ RunTime:0.014777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15378726 LIMIT 2 [ RunTime:0.008630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15378726 ORDER BY `minOrder` ASC [ RunTime:0.003107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14691852 LIMIT 5 [ RunTime:0.008250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14691852 ORDER BY `minOrder` ASC [ RunTime:0.003670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14691852 ORDER BY `unit` DESC [ RunTime:0.018724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14691852 LIMIT 2 [ RunTime:0.004474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14691852 ORDER BY `minOrder` ASC [ RunTime:0.002633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13803273 LIMIT 5 [ RunTime:0.001281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13803273 ORDER BY `minOrder` ASC [ RunTime:0.002454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13803273 ORDER BY `unit` DESC [ RunTime:0.000885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13803273 LIMIT 2 [ RunTime:0.018369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13803273 ORDER BY `minOrder` ASC [ RunTime:0.002809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520768 LIMIT 5 [ RunTime:0.004692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520768 ORDER BY `minOrder` ASC [ RunTime:0.001731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520768 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520768 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520768 ORDER BY `minOrder` ASC [ RunTime:0.004456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12262034 LIMIT 5 [ RunTime:0.004238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12262034 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12262034 ORDER BY `unit` DESC [ RunTime:0.007668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12262034 LIMIT 2 [ RunTime:0.003459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12262034 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003198s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62134160 LIMIT 5 [ RunTime:0.002988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134160 ORDER BY `minOrder` ASC [ RunTime:0.002315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62134160 ORDER BY `unit` DESC [ RunTime:0.001915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62134160 LIMIT 2 [ RunTime:0.001241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134160 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='1518083' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001625s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518083' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62140052 LIMIT 5 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62140052 ORDER BY `minOrder` ASC [ RunTime:0.001975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62140052 ORDER BY `unit` DESC [ RunTime:0.004341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62140052 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62140052 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='1518025' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518025' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64248134 LIMIT 5 [ RunTime:0.001746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64248134 ORDER BY `minOrder` ASC [ RunTime:0.001602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64248134 ORDER BY `unit` DESC [ RunTime:0.000807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64248134 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64248134 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
select * from pdf where partno='151805' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151805' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000501s ]
SELECT `id` FROM `stock` WHERE `id` <> 64248134 AND `partno` = '151805' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264637 [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63439642 LIMIT 5 [ RunTime:0.004157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439642 ORDER BY `minOrder` ASC [ RunTime:0.001877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63439642 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63439642 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439642 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='1518000' and brandshort='Rittal' limit 1 [ RunTime:0.004409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518000' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.013421s ]
SELECT `id` FROM `stock` WHERE `id` <> 63439642 AND `partno` = '1518000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.002587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62201820 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62201820 ORDER BY `minOrder` ASC [ RunTime:0.002214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62201820 ORDER BY `unit` DESC [ RunTime:0.002766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62201820 LIMIT 2 [ RunTime:0.002118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62201820 ORDER BY `minOrder` ASC [ RunTime:0.001228s ]
select * from pdf where partno='1518012' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518012' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62199395 LIMIT 5 [ RunTime:0.001822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62199395 ORDER BY `minOrder` ASC [ RunTime:0.002266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62199395 ORDER BY `unit` DESC [ RunTime:0.002349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62199395 LIMIT 2 [ RunTime:0.001002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62199395 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='1518009' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518009' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62199288 LIMIT 5 [ RunTime:0.003154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62199288 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62199288 ORDER BY `unit` DESC [ RunTime:0.006628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62199288 LIMIT 2 [ RunTime:0.003411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62199288 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
select * from pdf where partno='1518054' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518054' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62196916 LIMIT 5 [ RunTime:0.008150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62196916 ORDER BY `minOrder` ASC [ RunTime:0.004226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62196916 ORDER BY `unit` DESC [ RunTime:0.001415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62196916 LIMIT 2 [ RunTime:0.001634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62196916 ORDER BY `minOrder` ASC [ RunTime:0.004284s ]
select * from pdf where partno='1518096' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518096' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62194613 LIMIT 5 [ RunTime:0.001646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62194613 ORDER BY `minOrder` ASC [ RunTime:0.004059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62194613 ORDER BY `unit` DESC [ RunTime:0.010285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62194613 LIMIT 2 [ RunTime:0.028701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62194613 ORDER BY `minOrder` ASC [ RunTime:0.007818s ]
select * from pdf where partno='1518041' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518041' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62187484 LIMIT 5 [ RunTime:0.012867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62187484 ORDER BY `minOrder` ASC [ RunTime:0.012074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62187484 ORDER BY `unit` DESC [ RunTime:0.011921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62187484 LIMIT 2 [ RunTime:0.022884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62187484 ORDER BY `minOrder` ASC [ RunTime:0.007180s ]
select * from pdf where partno='1518070' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518070' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62186779 LIMIT 5 [ RunTime:0.006072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62186779 ORDER BY `minOrder` ASC [ RunTime:0.001202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62186779 ORDER BY `unit` DESC [ RunTime:0.019428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62186779 LIMIT 2 [ RunTime:0.016766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62186779 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='1518038' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518038' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62179589 LIMIT 5 [ RunTime:0.002154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179589 ORDER BY `minOrder` ASC [ RunTime:0.001299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62179589 ORDER BY `unit` DESC [ RunTime:0.005637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62179589 LIMIT 2 [ RunTime:0.020097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179589 ORDER BY `minOrder` ASC [ RunTime:0.010932s ]
select * from pdf where partno='1518067' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1518067' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61228016 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61228016 ORDER BY `minOrder` ASC [ RunTime:0.004960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61228016 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61228016 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61228016 ORDER BY `minOrder` ASC [ RunTime:0.002678s ]
select * from pdf where partno='15180-7SG-440' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.018617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15180-7SG-440' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.001015s ]
SELECT `id` FROM `stock` WHERE `id` <> 61228016 AND `partno` = '15180-7SG-440' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.001029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61228015 LIMIT 5 [ RunTime:0.001973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61228015 ORDER BY `minOrder` ASC [ RunTime:0.002465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61228015 ORDER BY `unit` DESC [ RunTime:0.006396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61228015 LIMIT 2 [ RunTime:0.008418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61228015 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='15180-7SG-457' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.001079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15180-7SG-457' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.001503s ]
SELECT `id` FROM `stock` WHERE `id` <> 61228015 AND `partno` = '15180-7SG-457' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.000843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61228014 LIMIT 5 [ RunTime:0.000853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61228014 ORDER BY `minOrder` ASC [ RunTime:0.001384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61228014 ORDER BY `unit` DESC [ RunTime:0.003771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61228014 LIMIT 2 [ RunTime:0.003797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61228014 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='15180-7SG-450' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.000755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15180-7SG-450' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.012656s ]
SELECT `id` FROM `stock` WHERE `id` <> 61228014 AND `partno` = '15180-7SG-450' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.002314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61217746 LIMIT 5 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217746 ORDER BY `minOrder` ASC [ RunTime:0.001308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61217746 ORDER BY `unit` DESC [ RunTime:0.006291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61217746 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217746 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='15180-7PG-457' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.006275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15180-7PG-457' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.001263s ]
SELECT `id` FROM `stock` WHERE `id` <> 61217746 AND `partno` = '15180-7PG-457' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.000824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61217745 LIMIT 5 [ RunTime:0.008768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217745 ORDER BY `minOrder` ASC [ RunTime:0.001880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61217745 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61217745 LIMIT 2 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217745 ORDER BY `minOrder` ASC [ RunTime:0.006590s ]
select * from pdf where partno='15180-7PG-440' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.002476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15180-7PG-440' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.015940s ]
SELECT `id` FROM `stock` WHERE `id` <> 61217745 AND `partno` = '15180-7PG-440' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.003815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61217744 LIMIT 5 [ RunTime:0.020828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217744 ORDER BY `minOrder` ASC [ RunTime:0.017997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61217744 ORDER BY `unit` DESC [ RunTime:0.018799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61217744 LIMIT 2 [ RunTime:0.003613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217744 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
select * from pdf where partno='15180-7PG-450' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.010398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15180-7PG-450' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.019382s ]
SELECT `id` FROM `stock` WHERE `id` <> 61217744 AND `partno` = '15180-7PG-450' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.009977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61217361 LIMIT 5 [ RunTime:0.023661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217361 ORDER BY `minOrder` ASC [ RunTime:0.020489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61217361 ORDER BY `unit` DESC [ RunTime:0.017579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61217361 LIMIT 2 [ RunTime:0.019712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217361 ORDER BY `minOrder` ASC [ RunTime:0.005776s ]
select * from pdf where partno='15180-7SG-321' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.024194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15180-7SG-321' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.033842s ]
SELECT `id` FROM `stock` WHERE `id` <> 61217361 AND `partno` = '15180-7SG-321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.005571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61217359 LIMIT 5 [ RunTime:0.011149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217359 ORDER BY `minOrder` ASC [ RunTime:0.009575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61217359 ORDER BY `unit` DESC [ RunTime:0.013918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61217359 LIMIT 2 [ RunTime:0.009726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61217359 ORDER BY `minOrder` ASC [ RunTime:0.012391s ]
select * from pdf where partno='15180-7SG-331' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.019395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15180-7SG-331' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.009462s ]
SELECT `id` FROM `stock` WHERE `id` <> 61217359 AND `partno` = '15180-7SG-331' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.026553s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019797s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032334s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016670s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021248s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013763s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006828s ]
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 '15180%' OR `brand` LIKE '15180%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029538s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15180%' OR `brand` LIKE '15180%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021628s ]