SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001446s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023351s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14687451 LIMIT 5 [ RunTime:0.012654s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.025566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687451 ORDER BY `minOrder` ASC [ RunTime:0.023034s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14687451 ORDER BY `unit` DESC [ RunTime:0.047347s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14687451 LIMIT 2 [ RunTime:0.030038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687451 ORDER BY `minOrder` ASC [ RunTime:0.056685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13791161 LIMIT 5 [ RunTime:0.025208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13791161 ORDER BY `minOrder` ASC [ RunTime:0.044225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13791161 ORDER BY `unit` DESC [ RunTime:0.113637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13791161 LIMIT 2 [ RunTime:0.071612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13791161 ORDER BY `minOrder` ASC [ RunTime:0.032104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605468 LIMIT 5 [ RunTime:0.065683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605468 ORDER BY `minOrder` ASC [ RunTime:0.031938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605468 ORDER BY `unit` DESC [ RunTime:0.044375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605468 LIMIT 2 [ RunTime:0.057443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605468 ORDER BY `minOrder` ASC [ RunTime:0.030187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662362 LIMIT 5 [ RunTime:0.076821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662362 ORDER BY `minOrder` ASC [ RunTime:0.098105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19662362 ORDER BY `unit` DESC [ RunTime:0.164296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19662362 LIMIT 2 [ RunTime:0.089243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662362 ORDER BY `minOrder` ASC [ RunTime:0.051550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662259 LIMIT 5 [ RunTime:0.093912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662259 ORDER BY `minOrder` ASC [ RunTime:0.057110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19662259 ORDER BY `unit` DESC [ RunTime:0.118202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19662259 LIMIT 2 [ RunTime:0.090271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662259 ORDER BY `minOrder` ASC [ RunTime:0.056144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14677304 LIMIT 5 [ RunTime:0.082269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677304 ORDER BY `minOrder` ASC [ RunTime:0.051837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14677304 ORDER BY `unit` DESC [ RunTime:0.044874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14677304 LIMIT 2 [ RunTime:0.050296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677304 ORDER BY `minOrder` ASC [ RunTime:0.005821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14676646 LIMIT 5 [ RunTime:0.056209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14676646 ORDER BY `minOrder` ASC [ RunTime:0.034935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14676646 ORDER BY `unit` DESC [ RunTime:0.034211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14676646 LIMIT 2 [ RunTime:0.021882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14676646 ORDER BY `minOrder` ASC [ RunTime:0.010253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13796462 LIMIT 5 [ RunTime:0.009897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13796462 ORDER BY `minOrder` ASC [ RunTime:0.013214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13796462 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13796462 LIMIT 2 [ RunTime:0.026020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13796462 ORDER BY `minOrder` ASC [ RunTime:0.010758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649990 LIMIT 5 [ RunTime:0.011389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649990 ORDER BY `minOrder` ASC [ RunTime:0.010649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649990 ORDER BY `unit` DESC [ RunTime:0.019106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649990 LIMIT 2 [ RunTime:0.005354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649990 ORDER BY `minOrder` ASC [ RunTime:0.001198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647750 LIMIT 5 [ RunTime:0.020512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647750 ORDER BY `minOrder` ASC [ RunTime:0.019041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647750 ORDER BY `unit` DESC [ RunTime:0.029436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647750 LIMIT 2 [ RunTime:0.067179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647750 ORDER BY `minOrder` ASC [ RunTime:0.014147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646903 LIMIT 5 [ RunTime:0.026609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646903 ORDER BY `minOrder` ASC [ RunTime:0.071617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19646903 ORDER BY `unit` DESC [ RunTime:0.027206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19646903 LIMIT 2 [ RunTime:0.003044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646903 ORDER BY `minOrder` ASC [ RunTime:0.004146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19641140 LIMIT 5 [ RunTime:0.021884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19641140 ORDER BY `minOrder` ASC [ RunTime:0.052400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19641140 ORDER BY `unit` DESC [ RunTime:0.008924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19641140 LIMIT 2 [ RunTime:0.001839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19641140 ORDER BY `minOrder` ASC [ RunTime:0.001760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17503036 LIMIT 5 [ RunTime:0.013558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17503036 ORDER BY `minOrder` ASC [ RunTime:0.070229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17503036 ORDER BY `unit` DESC [ RunTime:0.022086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17503036 LIMIT 2 [ RunTime:0.011183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17503036 ORDER BY `minOrder` ASC [ RunTime:0.018503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17502993 LIMIT 5 [ RunTime:0.034573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502993 ORDER BY `minOrder` ASC [ RunTime:0.005036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17502993 ORDER BY `unit` DESC [ RunTime:0.042312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17502993 LIMIT 2 [ RunTime:0.016582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502993 ORDER BY `minOrder` ASC [ RunTime:0.024654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17499470 LIMIT 5 [ RunTime:0.009219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17499470 ORDER BY `minOrder` ASC [ RunTime:0.029688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17499470 ORDER BY `unit` DESC [ RunTime:0.024065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17499470 LIMIT 2 [ RunTime:0.010599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17499470 ORDER BY `minOrder` ASC [ RunTime:0.014504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807893 LIMIT 5 [ RunTime:0.004515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807893 ORDER BY `minOrder` ASC [ RunTime:0.005997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13807893 ORDER BY `unit` DESC [ RunTime:0.008247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13807893 LIMIT 2 [ RunTime:0.022907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807893 ORDER BY `minOrder` ASC [ RunTime:0.002040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13787478 LIMIT 5 [ RunTime:0.012614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787478 ORDER BY `minOrder` ASC [ RunTime:0.017199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13787478 ORDER BY `unit` DESC [ RunTime:0.014385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13787478 LIMIT 2 [ RunTime:0.028839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13787478 ORDER BY `minOrder` ASC [ RunTime:0.008420s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036552s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55307131 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55307131 ORDER BY `minOrder` ASC [ RunTime:0.005505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55307131 ORDER BY `unit` DESC [ RunTime:0.008004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55307131 LIMIT 2 [ RunTime:0.003698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55307131 ORDER BY `minOrder` ASC [ RunTime:0.002785s ]
select * from pdf where partno='1430174' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023050s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430174' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53666030 LIMIT 5 [ RunTime:0.022532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666030 ORDER BY `minOrder` ASC [ RunTime:0.019322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53666030 ORDER BY `unit` DESC [ RunTime:0.034831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53666030 LIMIT 2 [ RunTime:0.040270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666030 ORDER BY `minOrder` ASC [ RunTime:0.006892s ]
select * from pdf where partno='1430130000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430130000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.065516s ]
SELECT `id` FROM `stock` WHERE `id` <> 53666030 AND `partno` = '1430130000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.076437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662362 [ RunTime:0.048246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55307139 LIMIT 5 [ RunTime:0.054057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55307139 ORDER BY `minOrder` ASC [ RunTime:0.043555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55307139 ORDER BY `unit` DESC [ RunTime:0.137185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55307139 LIMIT 2 [ RunTime:0.046997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55307139 ORDER BY `minOrder` ASC [ RunTime:0.030263s ]
select * from pdf where partno='1430129' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.028801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430129' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.047977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55307136 LIMIT 5 [ RunTime:0.058904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55307136 ORDER BY `minOrder` ASC [ RunTime:0.044764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55307136 ORDER BY `unit` DESC [ RunTime:0.030514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55307136 LIMIT 2 [ RunTime:0.091381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55307136 ORDER BY `minOrder` ASC [ RunTime:0.052293s ]
select * from pdf where partno='1430161' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.122552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430161' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.129380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53665867 LIMIT 5 [ RunTime:0.100223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665867 ORDER BY `minOrder` ASC [ RunTime:0.112651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53665867 ORDER BY `unit` DESC [ RunTime:0.051354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53665867 LIMIT 2 [ RunTime:0.114132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665867 ORDER BY `minOrder` ASC [ RunTime:0.002598s ]
select * from pdf where partno='1430120000' and brandshort='Weidmüller' limit 1 [ RunTime:0.016233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430120000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014836s ]
SELECT `id` FROM `stock` WHERE `id` <> 53665867 AND `partno` = '1430120000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.058608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662259 [ RunTime:0.010262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55309899 LIMIT 5 [ RunTime:0.047582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55309899 ORDER BY `minOrder` ASC [ RunTime:0.022290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55309899 ORDER BY `unit` DESC [ RunTime:0.009691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55309899 LIMIT 2 [ RunTime:0.029430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55309899 ORDER BY `minOrder` ASC [ RunTime:0.008903s ]
select * from pdf where partno='1430132' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430132' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55309963 LIMIT 5 [ RunTime:0.017683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55309963 ORDER BY `minOrder` ASC [ RunTime:0.014808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55309963 ORDER BY `unit` DESC [ RunTime:0.005197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55309963 LIMIT 2 [ RunTime:0.017630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55309963 ORDER BY `minOrder` ASC [ RunTime:0.018261s ]
select * from pdf where partno='1430158' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.035845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430158' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55322025 LIMIT 5 [ RunTime:0.012262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55322025 ORDER BY `minOrder` ASC [ RunTime:0.009228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55322025 ORDER BY `unit` DESC [ RunTime:0.010307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55322025 LIMIT 2 [ RunTime:0.013834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55322025 ORDER BY `minOrder` ASC [ RunTime:0.006653s ]
select * from pdf where partno='1430190' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430190' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56547416 LIMIT 5 [ RunTime:0.025340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56547416 ORDER BY `minOrder` ASC [ RunTime:0.004887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56547416 ORDER BY `unit` DESC [ RunTime:0.001365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56547416 LIMIT 2 [ RunTime:0.005575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56547416 ORDER BY `minOrder` ASC [ RunTime:0.006281s ]
select * from pdf where partno='14301' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.009930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14301' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.003927s ]
SELECT `id` FROM `stock` WHERE `id` <> 56547416 AND `partno` = '14301' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.005897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55381985 LIMIT 5 [ RunTime:0.002147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55381985 ORDER BY `minOrder` ASC [ RunTime:0.003077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55381985 ORDER BY `unit` DESC [ RunTime:0.001930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55381985 LIMIT 2 [ RunTime:0.010606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55381985 ORDER BY `minOrder` ASC [ RunTime:0.009710s ]
select * from pdf where partno='1430116' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430116' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55377820 LIMIT 5 [ RunTime:0.003518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55377820 ORDER BY `minOrder` ASC [ RunTime:0.004114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55377820 ORDER BY `unit` DESC [ RunTime:0.003087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55377820 LIMIT 2 [ RunTime:0.003883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55377820 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='1430103' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430103' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55319680 LIMIT 5 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55319680 ORDER BY `minOrder` ASC [ RunTime:0.008001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55319680 ORDER BY `unit` DESC [ RunTime:0.006410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55319680 LIMIT 2 [ RunTime:0.009956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55319680 ORDER BY `minOrder` ASC [ RunTime:0.008194s ]
select * from pdf where partno='1430145' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.017340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430145' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55319649 LIMIT 5 [ RunTime:0.003180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55319649 ORDER BY `minOrder` ASC [ RunTime:0.020081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55319649 ORDER BY `unit` DESC [ RunTime:0.006264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55319649 LIMIT 2 [ RunTime:0.046115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55319649 ORDER BY `minOrder` ASC [ RunTime:0.017524s ]
select * from pdf where partno='1430187' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430187' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53725557 LIMIT 5 [ RunTime:0.015906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53725557 ORDER BY `minOrder` ASC [ RunTime:0.009884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53725557 ORDER BY `unit` DESC [ RunTime:0.015393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53725557 LIMIT 2 [ RunTime:0.004044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53725557 ORDER BY `minOrder` ASC [ RunTime:0.013203s ]
select * from pdf where partno='1430100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.020120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.030916s ]
SELECT `id` FROM `stock` WHERE `id` <> 53725557 AND `partno` = '1430100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.029798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649990 [ RunTime:0.031855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53722978 LIMIT 5 [ RunTime:0.019805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53722978 ORDER BY `minOrder` ASC [ RunTime:0.011187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53722978 ORDER BY `unit` DESC [ RunTime:0.001332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53722978 LIMIT 2 [ RunTime:0.001083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53722978 ORDER BY `minOrder` ASC [ RunTime:0.016760s ]
select * from pdf where partno='1430190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430190000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.026140s ]
SELECT `id` FROM `stock` WHERE `id` <> 53722978 AND `partno` = '1430190000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.017859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647750 [ RunTime:0.024654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53721524 LIMIT 5 [ RunTime:0.013374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53721524 ORDER BY `minOrder` ASC [ RunTime:0.037816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53721524 ORDER BY `unit` DESC [ RunTime:0.015964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53721524 LIMIT 2 [ RunTime:0.010786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53721524 ORDER BY `minOrder` ASC [ RunTime:0.016890s ]
select * from pdf where partno='1430110000' and brandshort='Weidmüller' limit 1 [ RunTime:0.061366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430110000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.030337s ]
SELECT `id` FROM `stock` WHERE `id` <> 53721524 AND `partno` = '1430110000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.022045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646903 [ RunTime:0.031211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53714547 LIMIT 5 [ RunTime:0.013468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53714547 ORDER BY `minOrder` ASC [ RunTime:0.007466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53714547 ORDER BY `unit` DESC [ RunTime:0.020478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53714547 LIMIT 2 [ RunTime:0.018601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53714547 ORDER BY `minOrder` ASC [ RunTime:0.006474s ]
select * from pdf where partno='14301.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.009325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14301.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.009173s ]
SELECT `id` FROM `stock` WHERE `id` <> 53714547 AND `partno` = '14301.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.005564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19641140 [ RunTime:0.073355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53659226 LIMIT 5 [ RunTime:0.030770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53659226 ORDER BY `minOrder` ASC [ RunTime:0.075019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53659226 ORDER BY `unit` DESC [ RunTime:0.036760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53659226 LIMIT 2 [ RunTime:0.016958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53659226 ORDER BY `minOrder` ASC [ RunTime:0.007809s ]
select * from pdf where partno='1430140000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430140000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029132s ]
SELECT `id` FROM `stock` WHERE `id` <> 53659226 AND `partno` = '1430140000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.052734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605468 [ RunTime:0.009243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32722965 LIMIT 5 [ RunTime:0.018263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32722965 ORDER BY `minOrder` ASC [ RunTime:0.060356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32722965 ORDER BY `unit` DESC [ RunTime:0.025601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32722965 LIMIT 2 [ RunTime:0.084182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32722965 ORDER BY `minOrder` ASC [ RunTime:0.104481s ]
select * from pdf where partno='1430154001' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.026032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430154001' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.034243s ]
SELECT `id` FROM `stock` WHERE `id` <> 32722965 AND `partno` = '1430154001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.063534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32718005 LIMIT 5 [ RunTime:0.070717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32718005 ORDER BY `minOrder` ASC [ RunTime:0.038659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32718005 ORDER BY `unit` DESC [ RunTime:0.061358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32718005 LIMIT 2 [ RunTime:0.052939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32718005 ORDER BY `minOrder` ASC [ RunTime:0.013047s ]
select * from pdf where partno='1430150000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.037193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430150000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.110808s ]
SELECT `id` FROM `stock` WHERE `id` <> 32718005 AND `partno` = '1430150000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.066543s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052736s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032001s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050803s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064817s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019055s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045754s ]
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 '14301%' OR `brand` LIKE '14301%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038036s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '14301%' OR `brand` LIKE '14301%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.052504s ]