SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002610s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017122s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18765540 LIMIT 5 [ RunTime:0.029053s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765540 ORDER BY `minOrder` ASC [ RunTime:0.004006s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18765540 ORDER BY `unit` DESC [ RunTime:0.012568s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18765540 LIMIT 2 [ RunTime:0.012717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765540 ORDER BY `minOrder` ASC [ RunTime:0.019693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18748688 LIMIT 5 [ RunTime:0.008762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18748688 ORDER BY `minOrder` ASC [ RunTime:0.011974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18748688 ORDER BY `unit` DESC [ RunTime:0.022810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18748688 LIMIT 2 [ RunTime:0.009440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18748688 ORDER BY `minOrder` ASC [ RunTime:0.020949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218495 LIMIT 5 [ RunTime:0.046067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218495 ORDER BY `minOrder` ASC [ RunTime:0.016434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218495 ORDER BY `unit` DESC [ RunTime:0.033682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218495 LIMIT 2 [ RunTime:0.040163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218495 ORDER BY `minOrder` ASC [ RunTime:0.010318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425970 LIMIT 5 [ RunTime:0.048085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425970 ORDER BY `minOrder` ASC [ RunTime:0.063233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425970 ORDER BY `unit` DESC [ RunTime:0.089432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425970 LIMIT 2 [ RunTime:0.033946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425970 ORDER BY `minOrder` ASC [ RunTime:0.036459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557101 LIMIT 5 [ RunTime:0.024709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13557101 ORDER BY `minOrder` ASC [ RunTime:0.034741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13557101 ORDER BY `unit` DESC [ RunTime:0.053604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13557101 LIMIT 2 [ RunTime:0.070387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13557101 ORDER BY `minOrder` ASC [ RunTime:0.036831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166711 LIMIT 5 [ RunTime:0.027795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12166711 ORDER BY `minOrder` ASC [ RunTime:0.017096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12166711 ORDER BY `unit` DESC [ RunTime:0.019171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12166711 LIMIT 2 [ RunTime:0.031220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12166711 ORDER BY `minOrder` ASC [ RunTime:0.022063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12149257 LIMIT 5 [ RunTime:0.074348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12149257 ORDER BY `minOrder` ASC [ RunTime:0.065399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12149257 ORDER BY `unit` DESC [ RunTime:0.015596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12149257 LIMIT 2 [ RunTime:0.009488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12149257 ORDER BY `minOrder` ASC [ RunTime:0.018853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039976 LIMIT 5 [ RunTime:0.033433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039976 ORDER BY `minOrder` ASC [ RunTime:0.009675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039976 ORDER BY `unit` DESC [ RunTime:0.009241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039976 LIMIT 2 [ RunTime:0.021224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039976 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989674 LIMIT 5 [ RunTime:0.023597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989674 ORDER BY `minOrder` ASC [ RunTime:0.028521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11989674 ORDER BY `unit` DESC [ RunTime:0.021582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11989674 LIMIT 2 [ RunTime:0.011335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989674 ORDER BY `minOrder` ASC [ RunTime:0.001404s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010862s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57715113 LIMIT 5 [ RunTime:0.009885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57715113 ORDER BY `minOrder` ASC [ RunTime:0.009757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57715113 ORDER BY `unit` DESC [ RunTime:0.028619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57715113 LIMIT 2 [ RunTime:0.004250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57715113 ORDER BY `minOrder` ASC [ RunTime:0.007685s ]
select * from pdf where partno='46748' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016322s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46748' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008980s ]
SELECT `id` FROM `stock` WHERE `id` <> 57715113 AND `partno` = '46748' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557101 [ RunTime:0.017649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57715105 LIMIT 5 [ RunTime:0.016154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57715105 ORDER BY `minOrder` ASC [ RunTime:0.029851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57715105 ORDER BY `unit` DESC [ RunTime:0.005308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57715105 LIMIT 2 [ RunTime:0.014987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57715105 ORDER BY `minOrder` ASC [ RunTime:0.001828s ]
select * from pdf where partno='46741' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46741' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.012295s ]
SELECT `id` FROM `stock` WHERE `id` <> 57715105 AND `partno` = '46741' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.014582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425970 [ RunTime:0.009489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56577964 LIMIT 5 [ RunTime:0.019181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577964 ORDER BY `minOrder` ASC [ RunTime:0.051478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56577964 ORDER BY `unit` DESC [ RunTime:0.028617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56577964 LIMIT 2 [ RunTime:0.005646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577964 ORDER BY `minOrder` ASC [ RunTime:0.003221s ]
select * from pdf where partno='467450' and brandshort='Essentra Components' limit 1 [ RunTime:0.009493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '467450' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.009977s ]
SELECT `id` FROM `stock` WHERE `id` <> 56577964 AND `partno` = '467450' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.007254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56262868 LIMIT 5 [ RunTime:0.015952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56262868 ORDER BY `minOrder` ASC [ RunTime:0.030481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56262868 ORDER BY `unit` DESC [ RunTime:0.020164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56262868 LIMIT 2 [ RunTime:0.039574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56262868 ORDER BY `minOrder` ASC [ RunTime:0.016954s ]
select * from pdf where partno='4674' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.011359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4674' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.009376s ]
SELECT `id` FROM `stock` WHERE `id` <> 56262868 AND `partno` = '4674' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.045271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53801712 LIMIT 5 [ RunTime:0.011732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53801712 ORDER BY `minOrder` ASC [ RunTime:0.038186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53801712 ORDER BY `unit` DESC [ RunTime:0.033253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53801712 LIMIT 2 [ RunTime:0.031372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53801712 ORDER BY `minOrder` ASC [ RunTime:0.006886s ]
select * from pdf where partno='4674.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.017836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4674.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.024676s ]
SELECT `id` FROM `stock` WHERE `id` <> 53801712 AND `partno` = '4674.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.043535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51681769 LIMIT 5 [ RunTime:0.018242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51681769 ORDER BY `minOrder` ASC [ RunTime:0.028138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51681769 ORDER BY `unit` DESC [ RunTime:0.045397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51681769 LIMIT 2 [ RunTime:0.025731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51681769 ORDER BY `minOrder` ASC [ RunTime:0.016677s ]
select * from pdf where partno='46749-2' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.065275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46749-2' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.022211s ]
SELECT `id` FROM `stock` WHERE `id` <> 51681769 AND `partno` = '46749-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.038764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51638527 LIMIT 5 [ RunTime:0.020044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51638527 ORDER BY `minOrder` ASC [ RunTime:0.020773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51638527 ORDER BY `unit` DESC [ RunTime:0.026514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51638527 LIMIT 2 [ RunTime:0.045472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51638527 ORDER BY `minOrder` ASC [ RunTime:0.022190s ]
select * from pdf where partno='4674' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.028886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4674' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.025958s ]
SELECT `id` FROM `stock` WHERE `id` <> 51638527 AND `partno` = '4674' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.041055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12149257 [ RunTime:0.009505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50612155 LIMIT 5 [ RunTime:0.034963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50612155 ORDER BY `minOrder` ASC [ RunTime:0.074021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50612155 ORDER BY `unit` DESC [ RunTime:0.060535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50612155 LIMIT 2 [ RunTime:0.018363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50612155 ORDER BY `minOrder` ASC [ RunTime:0.025093s ]
select * from pdf where partno='4674ABX1G03937' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.019149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4674ABX1G03937' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.020804s ]
SELECT `id` FROM `stock` WHERE `id` <> 50612155 AND `partno` = '4674ABX1G03937' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.026095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989674 [ RunTime:0.024218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44644435 LIMIT 5 [ RunTime:0.033219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44644435 ORDER BY `minOrder` ASC [ RunTime:0.017651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44644435 ORDER BY `unit` DESC [ RunTime:0.019455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44644435 LIMIT 2 [ RunTime:0.017145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44644435 ORDER BY `minOrder` ASC [ RunTime:0.019466s ]
select * from pdf where partno='46749-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.035930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46749-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.025665s ]
SELECT `id` FROM `stock` WHERE `id` <> 44644435 AND `partno` = '46749-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.030911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18765540 [ RunTime:0.022472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44038990 LIMIT 5 [ RunTime:0.011350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44038990 ORDER BY `minOrder` ASC [ RunTime:0.024229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44038990 ORDER BY `unit` DESC [ RunTime:0.019295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44038990 LIMIT 2 [ RunTime:0.020230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44038990 ORDER BY `minOrder` ASC [ RunTime:0.013468s ]
select * from pdf where partno='467495-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.005825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '467495-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.021717s ]
SELECT `id` FROM `stock` WHERE `id` <> 44038990 AND `partno` = '467495-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.037570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18748688 [ RunTime:0.003813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37937685 LIMIT 5 [ RunTime:0.031207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37937685 ORDER BY `minOrder` ASC [ RunTime:0.012837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37937685 ORDER BY `unit` DESC [ RunTime:0.016104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37937685 LIMIT 2 [ RunTime:0.010802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37937685 ORDER BY `minOrder` ASC [ RunTime:0.014489s ]
select * from pdf where partno='4674ABX1G03937' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.017724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4674ABX1G03937' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.004324s ]
SELECT `id` FROM `stock` WHERE `id` <> 37937685 AND `partno` = '4674ABX1G03937' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.010821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989674 [ RunTime:0.004349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33128900 LIMIT 5 [ RunTime:0.006217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33128900 ORDER BY `minOrder` ASC [ RunTime:0.046726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33128900 ORDER BY `unit` DESC [ RunTime:0.016681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33128900 LIMIT 2 [ RunTime:0.006046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33128900 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='46749-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.004629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46749-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.006740s ]
SELECT `id` FROM `stock` WHERE `id` <> 33128900 AND `partno` = '46749-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.012926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18765540 [ RunTime:0.011099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32763545 LIMIT 5 [ RunTime:0.019099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32763545 ORDER BY `minOrder` ASC [ RunTime:0.006919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32763545 ORDER BY `unit` DESC [ RunTime:0.010227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32763545 LIMIT 2 [ RunTime:0.013820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32763545 ORDER BY `minOrder` ASC [ RunTime:0.006376s ]
select * from pdf where partno='46740ST9 (1000 PCS PACK)' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.011545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46740ST9 (1000 PCS PACK)' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004969s ]
SELECT `id` FROM `stock` WHERE `id` <> 32763545 AND `partno` = '46740ST9 (1000 PCS PACK)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.022945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32745988 LIMIT 5 [ RunTime:0.031768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32745988 ORDER BY `minOrder` ASC [ RunTime:0.025304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32745988 ORDER BY `unit` DESC [ RunTime:0.007445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32745988 LIMIT 2 [ RunTime:0.042426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32745988 ORDER BY `minOrder` ASC [ RunTime:0.013608s ]
select * from pdf where partno='46740PT9 (1000 PCS PACK)' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.013473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46740PT9 (1000 PCS PACK)' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.020579s ]
SELECT `id` FROM `stock` WHERE `id` <> 32745988 AND `partno` = '46740PT9 (1000 PCS PACK)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.006180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32335310 LIMIT 5 [ RunTime:0.014864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32335310 ORDER BY `minOrder` ASC [ RunTime:0.006663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32335310 ORDER BY `unit` DESC [ RunTime:0.002686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32335310 LIMIT 2 [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32335310 ORDER BY `minOrder` ASC [ RunTime:0.003136s ]
select * from pdf where partno='46740ST12' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.004679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46740ST12' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.009874s ]
SELECT `id` FROM `stock` WHERE `id` <> 32335310 AND `partno` = '46740ST12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.007878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32330749 LIMIT 5 [ RunTime:0.013390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32330749 ORDER BY `minOrder` ASC [ RunTime:0.006258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32330749 ORDER BY `unit` DESC [ RunTime:0.021212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32330749 LIMIT 2 [ RunTime:0.003509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32330749 ORDER BY `minOrder` ASC [ RunTime:0.007138s ]
select * from pdf where partno='46740PT12' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.018051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46740PT12' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.013218s ]
SELECT `id` FROM `stock` WHERE `id` <> 32330749 AND `partno` = '46740PT12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.024354s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020634s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016703s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012885s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001483s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004087s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001165s ]
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 '4674%' OR `brand` LIKE '4674%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017782s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4674%' OR `brand` LIKE '4674%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009486s ]