SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002681s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071877s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512431 LIMIT 5 [ RunTime:0.066049s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512431 ORDER BY `minOrder` ASC [ RunTime:0.018266s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.016958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512431 ORDER BY `unit` DESC [ RunTime:0.012975s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.023149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512431 LIMIT 2 [ RunTime:0.086484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512431 ORDER BY `minOrder` ASC [ RunTime:0.006971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12892785 LIMIT 5 [ RunTime:0.050553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892785 ORDER BY `minOrder` ASC [ RunTime:0.037558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12892785 ORDER BY `unit` DESC [ RunTime:0.065018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12892785 LIMIT 2 [ RunTime:0.047227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892785 ORDER BY `minOrder` ASC [ RunTime:0.031730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234041 LIMIT 5 [ RunTime:0.031920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234041 ORDER BY `minOrder` ASC [ RunTime:0.028123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234041 ORDER BY `unit` DESC [ RunTime:0.026241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234041 LIMIT 2 [ RunTime:0.055364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234041 ORDER BY `minOrder` ASC [ RunTime:0.030544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12891190 LIMIT 5 [ RunTime:0.031792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12891190 ORDER BY `minOrder` ASC [ RunTime:0.033904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12891190 ORDER BY `unit` DESC [ RunTime:0.024252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12891190 LIMIT 2 [ RunTime:0.041195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12891190 ORDER BY `minOrder` ASC [ RunTime:0.012005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234314 LIMIT 5 [ RunTime:0.026813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234314 ORDER BY `minOrder` ASC [ RunTime:0.007398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234314 ORDER BY `unit` DESC [ RunTime:0.024646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234314 LIMIT 2 [ RunTime:0.035911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234314 ORDER BY `minOrder` ASC [ RunTime:0.019557s ]
select * from pdf where partno='1302031085' and brandshort='Molex' limit 1 [ RunTime:0.010565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12892284 LIMIT 5 [ RunTime:0.012878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892284 ORDER BY `minOrder` ASC [ RunTime:0.012982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12892284 ORDER BY `unit` DESC [ RunTime:0.020534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12892284 LIMIT 2 [ RunTime:0.023141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892284 ORDER BY `minOrder` ASC [ RunTime:0.043745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12892285 LIMIT 5 [ RunTime:0.018794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892285 ORDER BY `minOrder` ASC [ RunTime:0.005577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12892285 ORDER BY `unit` DESC [ RunTime:0.009094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12892285 LIMIT 2 [ RunTime:0.026377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892285 ORDER BY `minOrder` ASC [ RunTime:0.013834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11690122 LIMIT 5 [ RunTime:0.027849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11690122 ORDER BY `minOrder` ASC [ RunTime:0.029064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11690122 ORDER BY `unit` DESC [ RunTime:0.027811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11690122 LIMIT 2 [ RunTime:0.020866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11690122 ORDER BY `minOrder` ASC [ RunTime:0.011310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11689602 LIMIT 5 [ RunTime:0.022947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11689602 ORDER BY `minOrder` ASC [ RunTime:0.020519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11689602 ORDER BY `unit` DESC [ RunTime:0.029598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11689602 LIMIT 2 [ RunTime:0.019712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11689602 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18832608 LIMIT 5 [ RunTime:0.026639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832608 ORDER BY `minOrder` ASC [ RunTime:0.025598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18832608 ORDER BY `unit` DESC [ RunTime:0.023615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18832608 LIMIT 2 [ RunTime:0.010713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832608 ORDER BY `minOrder` ASC [ RunTime:0.003971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14184983 LIMIT 5 [ RunTime:0.021265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14184983 ORDER BY `minOrder` ASC [ RunTime:0.002281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14184983 ORDER BY `unit` DESC [ RunTime:0.005365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14184983 LIMIT 2 [ RunTime:0.016429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14184983 ORDER BY `minOrder` ASC [ RunTime:0.004979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12892617 LIMIT 5 [ RunTime:0.013150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892617 ORDER BY `minOrder` ASC [ RunTime:0.007926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12892617 ORDER BY `unit` DESC [ RunTime:0.011930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12892617 LIMIT 2 [ RunTime:0.005858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892617 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12892331 LIMIT 5 [ RunTime:0.003953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892331 ORDER BY `minOrder` ASC [ RunTime:0.003375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12892331 ORDER BY `unit` DESC [ RunTime:0.005952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12892331 LIMIT 2 [ RunTime:0.014333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892331 ORDER BY `minOrder` ASC [ RunTime:0.011145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18834072 LIMIT 5 [ RunTime:0.001129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834072 ORDER BY `minOrder` ASC [ RunTime:0.001694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18834072 ORDER BY `unit` DESC [ RunTime:0.026719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18834072 LIMIT 2 [ RunTime:0.015986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834072 ORDER BY `minOrder` ASC [ RunTime:0.006099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18834059 LIMIT 5 [ RunTime:0.010713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834059 ORDER BY `minOrder` ASC [ RunTime:0.013745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18834059 ORDER BY `unit` DESC [ RunTime:0.000915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18834059 LIMIT 2 [ RunTime:0.007971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834059 ORDER BY `minOrder` ASC [ RunTime:0.003765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18833439 LIMIT 5 [ RunTime:0.015910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833439 ORDER BY `minOrder` ASC [ RunTime:0.038166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18833439 ORDER BY `unit` DESC [ RunTime:0.006756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18833439 LIMIT 2 [ RunTime:0.015616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833439 ORDER BY `minOrder` ASC [ RunTime:0.012689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18833394 LIMIT 5 [ RunTime:0.012378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833394 ORDER BY `minOrder` ASC [ RunTime:0.028529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18833394 ORDER BY `unit` DESC [ RunTime:0.002623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18833394 LIMIT 2 [ RunTime:0.018319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833394 ORDER BY `minOrder` ASC [ RunTime:0.007575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18832907 LIMIT 5 [ RunTime:0.011605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832907 ORDER BY `minOrder` ASC [ RunTime:0.004827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18832907 ORDER BY `unit` DESC [ RunTime:0.007694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18832907 LIMIT 2 [ RunTime:0.022487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832907 ORDER BY `minOrder` ASC [ RunTime:0.004488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18832894 LIMIT 5 [ RunTime:0.003938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832894 ORDER BY `minOrder` ASC [ RunTime:0.012916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18832894 ORDER BY `unit` DESC [ RunTime:0.026756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18832894 LIMIT 2 [ RunTime:0.007033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832894 ORDER BY `minOrder` ASC [ RunTime:0.006553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18832667 LIMIT 5 [ RunTime:0.008569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832667 ORDER BY `minOrder` ASC [ RunTime:0.002819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18832667 ORDER BY `unit` DESC [ RunTime:0.009876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18832667 LIMIT 2 [ RunTime:0.009883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832667 ORDER BY `minOrder` ASC [ RunTime:0.011973s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086156 LIMIT 5 [ RunTime:0.024038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086156 ORDER BY `minOrder` ASC [ RunTime:0.027023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086156 ORDER BY `unit` DESC [ RunTime:0.005631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086156 LIMIT 2 [ RunTime:0.007811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086156 ORDER BY `minOrder` ASC [ RunTime:0.010835s ]
select * from pdf where partno='1302011688' and brandshort='molex' limit 1 [ RunTime:0.013717s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011688' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.055809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32272451 LIMIT 5 [ RunTime:0.017268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272451 ORDER BY `minOrder` ASC [ RunTime:0.035341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32272451 ORDER BY `unit` DESC [ RunTime:0.014191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32272451 LIMIT 2 [ RunTime:0.009676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272451 ORDER BY `minOrder` ASC [ RunTime:0.015579s ]
select * from pdf where partno='1302011688' and brandshort='molex' limit 1 [ RunTime:0.003052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011688' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.000702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095177 LIMIT 5 [ RunTime:0.005329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095177 ORDER BY `minOrder` ASC [ RunTime:0.012949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095177 ORDER BY `unit` DESC [ RunTime:0.022690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095177 LIMIT 2 [ RunTime:0.033279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095177 ORDER BY `minOrder` ASC [ RunTime:0.009766s ]
select * from pdf where partno='13020' and brandshort='desco' limit 1 [ RunTime:0.013427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13020' OR `brand` LIKE 'desco%' ) ) LIMIT 1 [ RunTime:0.041163s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095177 AND `partno` = '13020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.015689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12387973 [ RunTime:0.005184s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53824992 LIMIT 5 [ RunTime:0.023602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53824992 ORDER BY `minOrder` ASC [ RunTime:0.038837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53824992 ORDER BY `unit` DESC [ RunTime:0.018250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53824992 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53824992 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='130205' and brandshort='TE Connectivity' limit 1 [ RunTime:0.010455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '130205' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.022188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58545956 LIMIT 5 [ RunTime:0.010305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58545956 ORDER BY `minOrder` ASC [ RunTime:0.036989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58545956 ORDER BY `unit` DESC [ RunTime:0.009982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58545956 LIMIT 2 [ RunTime:0.003190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58545956 ORDER BY `minOrder` ASC [ RunTime:0.003299s ]
select * from pdf where partno='1302031250' and brandshort='Molex' limit 1 [ RunTime:0.001454s ]
select foldpath,foldpath2,filename from pdf_file where id=906362 limit 1 [ RunTime:0.018678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302031250' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60324618 LIMIT 5 [ RunTime:0.003032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324618 ORDER BY `minOrder` ASC [ RunTime:0.035602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60324618 ORDER BY `unit` DESC [ RunTime:0.010801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60324618 LIMIT 2 [ RunTime:0.009523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324618 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
select * from pdf where partno='1302011109' and brandshort='Molex' limit 1 [ RunTime:0.007468s ]
select foldpath,foldpath2,filename from pdf_file where id=1881308 limit 1 [ RunTime:0.024214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011109' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60325027 LIMIT 5 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60325027 ORDER BY `minOrder` ASC [ RunTime:0.007097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60325027 ORDER BY `unit` DESC [ RunTime:0.006049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60325027 LIMIT 2 [ RunTime:0.022458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60325027 ORDER BY `minOrder` ASC [ RunTime:0.009855s ]
select * from pdf where partno='1302011116' and brandshort='Molex' limit 1 [ RunTime:0.017722s ]
select foldpath,foldpath2,filename from pdf_file where id=1665713 limit 1 [ RunTime:0.017326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011116' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60324972 LIMIT 5 [ RunTime:0.064598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324972 ORDER BY `minOrder` ASC [ RunTime:0.026720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60324972 ORDER BY `unit` DESC [ RunTime:0.034167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60324972 LIMIT 2 [ RunTime:0.026330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324972 ORDER BY `minOrder` ASC [ RunTime:0.011672s ]
select * from pdf where partno='1302011111' and brandshort='Molex' limit 1 [ RunTime:0.005623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011111' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.038708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60647759 LIMIT 5 [ RunTime:0.028383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60647759 ORDER BY `minOrder` ASC [ RunTime:0.021378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60647759 ORDER BY `unit` DESC [ RunTime:0.022263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60647759 LIMIT 2 [ RunTime:0.019988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60647759 ORDER BY `minOrder` ASC [ RunTime:0.013580s ]
select * from pdf where partno='130207' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.021752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '130207' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.052965s ]
SELECT `id` FROM `stock` WHERE `id` <> 60647759 AND `partno` = '130207' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.051254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64101073 LIMIT 5 [ RunTime:0.021994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64101073 ORDER BY `minOrder` ASC [ RunTime:0.018885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64101073 ORDER BY `unit` DESC [ RunTime:0.016719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64101073 LIMIT 2 [ RunTime:0.013533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64101073 ORDER BY `minOrder` ASC [ RunTime:0.012076s ]
select * from pdf where partno='1302030432' and brandshort='Molex' limit 1 [ RunTime:0.035625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302030432' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.044877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64101285 LIMIT 5 [ RunTime:0.048523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64101285 ORDER BY `minOrder` ASC [ RunTime:0.013047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64101285 ORDER BY `unit` DESC [ RunTime:0.027492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64101285 LIMIT 2 [ RunTime:0.101754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64101285 ORDER BY `minOrder` ASC [ RunTime:0.021417s ]
select * from pdf where partno='1302031085' and brandshort='Molex' limit 1 [ RunTime:0.007669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302031085' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.045238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60327141 LIMIT 5 [ RunTime:0.013925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60327141 ORDER BY `minOrder` ASC [ RunTime:0.029668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60327141 ORDER BY `unit` DESC [ RunTime:0.021096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60327141 LIMIT 2 [ RunTime:0.038691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60327141 ORDER BY `minOrder` ASC [ RunTime:0.008644s ]
select * from pdf where partno='1302011113' and brandshort='Molex' limit 1 [ RunTime:0.014449s ]
select foldpath,foldpath2,filename from pdf_file where id=755376 limit 1 [ RunTime:0.033425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011113' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.028295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60325063 LIMIT 5 [ RunTime:0.008832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60325063 ORDER BY `minOrder` ASC [ RunTime:0.016975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60325063 ORDER BY `unit` DESC [ RunTime:0.014317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60325063 LIMIT 2 [ RunTime:0.005922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60325063 ORDER BY `minOrder` ASC [ RunTime:0.007455s ]
select * from pdf where partno='1302011120' and brandshort='Molex' limit 1 [ RunTime:0.033099s ]
select foldpath,foldpath2,filename from pdf_file where id=1612694 limit 1 [ RunTime:0.015229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011120' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.033577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60327142 LIMIT 5 [ RunTime:0.027477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60327142 ORDER BY `minOrder` ASC [ RunTime:0.053235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60327142 ORDER BY `unit` DESC [ RunTime:0.009546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60327142 LIMIT 2 [ RunTime:0.015713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60327142 ORDER BY `minOrder` ASC [ RunTime:0.001576s ]
select * from pdf where partno='1302011118' and brandshort='Molex' limit 1 [ RunTime:0.022000s ]
select foldpath,foldpath2,filename from pdf_file where id=1613723 limit 1 [ RunTime:0.028778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011118' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64058890 LIMIT 5 [ RunTime:0.004723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64058890 ORDER BY `minOrder` ASC [ RunTime:0.001762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64058890 ORDER BY `unit` DESC [ RunTime:0.007337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64058890 LIMIT 2 [ RunTime:0.017144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64058890 ORDER BY `minOrder` ASC [ RunTime:0.013293s ]
select * from pdf where partno='1302030523' and brandshort='Molex' limit 1 [ RunTime:0.006569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302030523' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62141213 LIMIT 5 [ RunTime:0.043986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62141213 ORDER BY `minOrder` ASC [ RunTime:0.037077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62141213 ORDER BY `unit` DESC [ RunTime:0.008289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62141213 LIMIT 2 [ RunTime:0.005480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62141213 ORDER BY `minOrder` ASC [ RunTime:0.012962s ]
select * from pdf where partno='1302030548' and brandshort='Molex' limit 1 [ RunTime:0.029880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302030548' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.031490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60334880 LIMIT 5 [ RunTime:0.023389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60334880 ORDER BY `minOrder` ASC [ RunTime:0.008998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60334880 ORDER BY `unit` DESC [ RunTime:0.020670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60334880 LIMIT 2 [ RunTime:0.018865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60334880 ORDER BY `minOrder` ASC [ RunTime:0.024471s ]
select * from pdf where partno='1302011119' and brandshort='Molex' limit 1 [ RunTime:0.019286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011119' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64065224 LIMIT 5 [ RunTime:0.013731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64065224 ORDER BY `minOrder` ASC [ RunTime:0.024435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64065224 ORDER BY `unit` DESC [ RunTime:0.013546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64065224 LIMIT 2 [ RunTime:0.042817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64065224 ORDER BY `minOrder` ASC [ RunTime:0.002994s ]
select * from pdf where partno='1302000898' and brandshort='Molex' limit 1 [ RunTime:0.007155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302000898' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.056880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64059057 LIMIT 5 [ RunTime:0.030747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64059057 ORDER BY `minOrder` ASC [ RunTime:0.048102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64059057 ORDER BY `unit` DESC [ RunTime:0.042086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64059057 LIMIT 2 [ RunTime:0.048767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64059057 ORDER BY `minOrder` ASC [ RunTime:0.004714s ]
select * from pdf where partno='1302010878' and brandshort='Molex' limit 1 [ RunTime:0.012075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302010878' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.026907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60327506 LIMIT 5 [ RunTime:0.009313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60327506 ORDER BY `minOrder` ASC [ RunTime:0.013016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60327506 ORDER BY `unit` DESC [ RunTime:0.017052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60327506 LIMIT 2 [ RunTime:0.010958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60327506 ORDER BY `minOrder` ASC [ RunTime:0.001629s ]
select * from pdf where partno='1302011024' and brandshort='Molex' limit 1 [ RunTime:0.004292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011024' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.029966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60327152 LIMIT 5 [ RunTime:0.012724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60327152 ORDER BY `minOrder` ASC [ RunTime:0.032408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60327152 ORDER BY `unit` DESC [ RunTime:0.014868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60327152 LIMIT 2 [ RunTime:0.032278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60327152 ORDER BY `minOrder` ASC [ RunTime:0.001608s ]
select * from pdf where partno='1302011110' and brandshort='Molex' limit 1 [ RunTime:0.023609s ]
select foldpath,foldpath2,filename from pdf_file where id=755376 limit 1 [ RunTime:0.010239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302011110' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.040507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64101937 LIMIT 5 [ RunTime:0.022334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64101937 ORDER BY `minOrder` ASC [ RunTime:0.061342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64101937 ORDER BY `unit` DESC [ RunTime:0.005525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64101937 LIMIT 2 [ RunTime:0.016090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64101937 ORDER BY `minOrder` ASC [ RunTime:0.014574s ]
select * from pdf where partno='1302030517' and brandshort='Molex' limit 1 [ RunTime:0.010484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302030517' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.061247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64101900 LIMIT 5 [ RunTime:0.029907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64101900 ORDER BY `minOrder` ASC [ RunTime:0.040098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64101900 ORDER BY `unit` DESC [ RunTime:0.018288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64101900 LIMIT 2 [ RunTime:0.052282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64101900 ORDER BY `minOrder` ASC [ RunTime:0.020585s ]
select * from pdf where partno='1302030649' and brandshort='Molex' limit 1 [ RunTime:0.018039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1302030649' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.040635s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003697s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028972s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018427s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032489s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044369s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017540s ]
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 '13020%' OR `brand` LIKE '13020%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029155s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '13020%' OR `brand` LIKE '13020%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003899s ]