SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001197s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023623s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417091 LIMIT 5 [ RunTime:0.010619s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417091 ORDER BY `minOrder` ASC [ RunTime:0.018612s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417091 ORDER BY `unit` DESC [ RunTime:0.040703s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417091 LIMIT 2 [ RunTime:0.015664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417091 ORDER BY `minOrder` ASC [ RunTime:0.014519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418812 LIMIT 5 [ RunTime:0.029847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418812 ORDER BY `minOrder` ASC [ RunTime:0.020562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418812 ORDER BY `unit` DESC [ RunTime:0.071452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418812 LIMIT 2 [ RunTime:0.009866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418812 ORDER BY `minOrder` ASC [ RunTime:0.020228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14709511 LIMIT 5 [ RunTime:0.034156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709511 ORDER BY `minOrder` ASC [ RunTime:0.010537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14709511 ORDER BY `unit` DESC [ RunTime:0.055252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14709511 LIMIT 2 [ RunTime:0.046798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709511 ORDER BY `minOrder` ASC [ RunTime:0.009319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373472 LIMIT 5 [ RunTime:0.017163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373472 ORDER BY `minOrder` ASC [ RunTime:0.024441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13373472 ORDER BY `unit` DESC [ RunTime:0.007360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13373472 LIMIT 2 [ RunTime:0.035040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373472 ORDER BY `minOrder` ASC [ RunTime:0.010240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13844430 LIMIT 5 [ RunTime:0.034165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13844430 ORDER BY `minOrder` ASC [ RunTime:0.029423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13844430 ORDER BY `unit` DESC [ RunTime:0.029052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13844430 LIMIT 2 [ RunTime:0.024573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13844430 ORDER BY `minOrder` ASC [ RunTime:0.001246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13354681 LIMIT 5 [ RunTime:0.028180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13354681 ORDER BY `minOrder` ASC [ RunTime:0.068592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13354681 ORDER BY `unit` DESC [ RunTime:0.025860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13354681 LIMIT 2 [ RunTime:0.029168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13354681 ORDER BY `minOrder` ASC [ RunTime:0.001259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13834970 LIMIT 5 [ RunTime:0.018898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13834970 ORDER BY `minOrder` ASC [ RunTime:0.051504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13834970 ORDER BY `unit` DESC [ RunTime:0.039171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13834970 LIMIT 2 [ RunTime:0.020827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13834970 ORDER BY `minOrder` ASC [ RunTime:0.006855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724515 LIMIT 5 [ RunTime:0.015126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724515 ORDER BY `minOrder` ASC [ RunTime:0.031523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14724515 ORDER BY `unit` DESC [ RunTime:0.031513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14724515 LIMIT 2 [ RunTime:0.007884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724515 ORDER BY `minOrder` ASC [ RunTime:0.010096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13833830 LIMIT 5 [ RunTime:0.015463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13833830 ORDER BY `minOrder` ASC [ RunTime:0.004733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13833830 ORDER BY `unit` DESC [ RunTime:0.006609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13833830 LIMIT 2 [ RunTime:0.010508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13833830 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13842998 LIMIT 5 [ RunTime:0.010026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13842998 ORDER BY `minOrder` ASC [ RunTime:0.005516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13842998 ORDER BY `unit` DESC [ RunTime:0.007363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13842998 LIMIT 2 [ RunTime:0.006818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13842998 ORDER BY `minOrder` ASC [ RunTime:0.011187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724516 LIMIT 5 [ RunTime:0.021988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724516 ORDER BY `minOrder` ASC [ RunTime:0.020632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14724516 ORDER BY `unit` DESC [ RunTime:0.011839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14724516 LIMIT 2 [ RunTime:0.014268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724516 ORDER BY `minOrder` ASC [ RunTime:0.006006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13842999 LIMIT 5 [ RunTime:0.025588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13842999 ORDER BY `minOrder` ASC [ RunTime:0.005709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13842999 ORDER BY `unit` DESC [ RunTime:0.002310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13842999 LIMIT 2 [ RunTime:0.009448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13842999 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13902858 LIMIT 5 [ RunTime:0.001189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13902858 ORDER BY `minOrder` ASC [ RunTime:0.003840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13902858 ORDER BY `unit` DESC [ RunTime:0.001631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13902858 LIMIT 2 [ RunTime:0.002703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13902858 ORDER BY `minOrder` ASC [ RunTime:0.002307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13843000 LIMIT 5 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13843000 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13843000 ORDER BY `unit` DESC [ RunTime:0.000315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13843000 LIMIT 2 [ RunTime:0.002485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13843000 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13355920 LIMIT 5 [ RunTime:0.002766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13355920 ORDER BY `minOrder` ASC [ RunTime:0.005069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13355920 ORDER BY `unit` DESC [ RunTime:0.007893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13355920 LIMIT 2 [ RunTime:0.002392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13355920 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14736500 LIMIT 5 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14736500 ORDER BY `minOrder` ASC [ RunTime:0.008693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14736500 ORDER BY `unit` DESC [ RunTime:0.013100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14736500 LIMIT 2 [ RunTime:0.048829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14736500 ORDER BY `minOrder` ASC [ RunTime:0.018396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724517 LIMIT 5 [ RunTime:0.002370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724517 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14724517 ORDER BY `unit` DESC [ RunTime:0.000522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14724517 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724517 ORDER BY `minOrder` ASC [ RunTime:0.001735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724511 LIMIT 5 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724511 ORDER BY `minOrder` ASC [ RunTime:0.001313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14724511 ORDER BY `unit` DESC [ RunTime:0.005775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14724511 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724511 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13833253 LIMIT 5 [ RunTime:0.010834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13833253 ORDER BY `minOrder` ASC [ RunTime:0.009289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13833253 ORDER BY `unit` DESC [ RunTime:0.005107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13833253 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13833253 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13356168 LIMIT 5 [ RunTime:0.007403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13356168 ORDER BY `minOrder` ASC [ RunTime:0.005027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13356168 ORDER BY `unit` DESC [ RunTime:0.020270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13356168 LIMIT 2 [ RunTime:0.011165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13356168 ORDER BY `minOrder` ASC [ RunTime:0.018835s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282181 LIMIT 5 [ RunTime:0.017539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282181 ORDER BY `minOrder` ASC [ RunTime:0.021272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282181 ORDER BY `unit` DESC [ RunTime:0.005149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282181 LIMIT 2 [ RunTime:0.008421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282181 ORDER BY `minOrder` ASC [ RunTime:0.007135s ]
select * from pdf where partno='280095-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.004235s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '280095-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.006977s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282181 AND `partno` = '280095-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.008947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090225 LIMIT 5 [ RunTime:0.009255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090225 ORDER BY `minOrder` ASC [ RunTime:0.005456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090225 ORDER BY `unit` DESC [ RunTime:0.003018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090225 LIMIT 2 [ RunTime:0.005768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090225 ORDER BY `minOrder` ASC [ RunTime:0.005045s ]
select * from pdf where partno='2800977' and brandshort='phoenix contact' limit 1 [ RunTime:0.012485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800977' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.028971s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640112 LIMIT 5 [ RunTime:0.009066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640112 ORDER BY `minOrder` ASC [ RunTime:0.017073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640112 ORDER BY `unit` DESC [ RunTime:0.033260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640112 LIMIT 2 [ RunTime:0.017303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640112 ORDER BY `minOrder` ASC [ RunTime:0.004937s ]
select * from pdf where partno='280098-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '280098-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018693s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640112 AND `partno` = '280098-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417091 [ RunTime:0.000405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639349 LIMIT 5 [ RunTime:0.008433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639349 ORDER BY `minOrder` ASC [ RunTime:0.008661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639349 ORDER BY `unit` DESC [ RunTime:0.007530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639349 LIMIT 2 [ RunTime:0.015122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639349 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='280095-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '280095-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009165s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639349 AND `partno` = '280095-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517330 [ RunTime:0.003843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60319172 LIMIT 5 [ RunTime:0.002997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60319172 ORDER BY `minOrder` ASC [ RunTime:0.006851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60319172 ORDER BY `unit` DESC [ RunTime:0.012028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60319172 LIMIT 2 [ RunTime:0.005852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60319172 ORDER BY `minOrder` ASC [ RunTime:0.008755s ]
select * from pdf where partno='280099' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '280099' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014746s ]
SELECT `id` FROM `stock` WHERE `id` <> 60319172 AND `partno` = '280099' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.014029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418812 [ RunTime:0.017402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58207047 LIMIT 5 [ RunTime:0.004911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207047 ORDER BY `minOrder` ASC [ RunTime:0.038020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58207047 ORDER BY `unit` DESC [ RunTime:0.024517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58207047 LIMIT 2 [ RunTime:0.051343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207047 ORDER BY `minOrder` ASC [ RunTime:0.018055s ]
select * from pdf where partno='2800929' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800929' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64414638 LIMIT 5 [ RunTime:0.014978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64414638 ORDER BY `minOrder` ASC [ RunTime:0.012249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64414638 ORDER BY `unit` DESC [ RunTime:0.013360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64414638 LIMIT 2 [ RunTime:0.016020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64414638 ORDER BY `minOrder` ASC [ RunTime:0.001150s ]
select * from pdf where partno='28009' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.003489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '28009' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.004886s ]
SELECT `id` FROM `stock` WHERE `id` <> 64414638 AND `partno` = '28009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.015998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373472 [ RunTime:0.005405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41860877 LIMIT 5 [ RunTime:0.016192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41860877 ORDER BY `minOrder` ASC [ RunTime:0.019101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41860877 ORDER BY `unit` DESC [ RunTime:0.020351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41860877 LIMIT 2 [ RunTime:0.019992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41860877 ORDER BY `minOrder` ASC [ RunTime:0.004299s ]
select * from pdf where partno='2800904' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.031345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800904' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541396 LIMIT 5 [ RunTime:0.014676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541396 ORDER BY `minOrder` ASC [ RunTime:0.026580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541396 ORDER BY `unit` DESC [ RunTime:0.016452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541396 LIMIT 2 [ RunTime:0.021689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541396 ORDER BY `minOrder` ASC [ RunTime:0.009307s ]
select * from pdf where partno='2800976' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800976' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.033982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41864381 LIMIT 5 [ RunTime:0.025638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41864381 ORDER BY `minOrder` ASC [ RunTime:0.022038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41864381 ORDER BY `unit` DESC [ RunTime:0.003125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41864381 LIMIT 2 [ RunTime:0.002268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41864381 ORDER BY `minOrder` ASC [ RunTime:0.002207s ]
select * from pdf where partno='2800900' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800900' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41869277 LIMIT 5 [ RunTime:0.012219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869277 ORDER BY `minOrder` ASC [ RunTime:0.012326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41869277 ORDER BY `unit` DESC [ RunTime:0.000831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41869277 LIMIT 2 [ RunTime:0.003123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869277 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
select * from pdf where partno='2800922' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800922' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41869257 LIMIT 5 [ RunTime:0.026612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869257 ORDER BY `minOrder` ASC [ RunTime:0.022492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41869257 ORDER BY `unit` DESC [ RunTime:0.004130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41869257 LIMIT 2 [ RunTime:0.008932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869257 ORDER BY `minOrder` ASC [ RunTime:0.004117s ]
select * from pdf where partno='2800923' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800923' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541462 LIMIT 5 [ RunTime:0.005432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541462 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541462 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541462 LIMIT 2 [ RunTime:0.009453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541462 ORDER BY `minOrder` ASC [ RunTime:0.008501s ]
select * from pdf where partno='2800982' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800982' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41869259 LIMIT 5 [ RunTime:0.013727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869259 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41869259 ORDER BY `unit` DESC [ RunTime:0.006645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41869259 LIMIT 2 [ RunTime:0.006915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869259 ORDER BY `minOrder` ASC [ RunTime:0.003700s ]
select * from pdf where partno='2800915' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800915' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41869258 LIMIT 5 [ RunTime:0.010872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869258 ORDER BY `minOrder` ASC [ RunTime:0.013445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41869258 ORDER BY `unit` DESC [ RunTime:0.021895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41869258 LIMIT 2 [ RunTime:0.028788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869258 ORDER BY `minOrder` ASC [ RunTime:0.008680s ]
select * from pdf where partno='2800908' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800908' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541726 LIMIT 5 [ RunTime:0.010785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541726 ORDER BY `minOrder` ASC [ RunTime:0.001240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541726 ORDER BY `unit` DESC [ RunTime:0.011330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541726 LIMIT 2 [ RunTime:0.013198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541726 ORDER BY `minOrder` ASC [ RunTime:0.011522s ]
select * from pdf where partno='2800995' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800995' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64123061 LIMIT 5 [ RunTime:0.011205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64123061 ORDER BY `minOrder` ASC [ RunTime:0.006853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64123061 ORDER BY `unit` DESC [ RunTime:0.006050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64123061 LIMIT 2 [ RunTime:0.001294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64123061 ORDER BY `minOrder` ASC [ RunTime:0.000567s ]
select * from pdf where partno='2800989' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800989' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541460 LIMIT 5 [ RunTime:0.006317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541460 ORDER BY `minOrder` ASC [ RunTime:0.010278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541460 ORDER BY `unit` DESC [ RunTime:0.002726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541460 LIMIT 2 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541460 ORDER BY `minOrder` ASC [ RunTime:0.001440s ]
select * from pdf where partno='2800980' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800980' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41869260 LIMIT 5 [ RunTime:0.006220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869260 ORDER BY `minOrder` ASC [ RunTime:0.003217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41869260 ORDER BY `unit` DESC [ RunTime:0.007850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41869260 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41869260 ORDER BY `minOrder` ASC [ RunTime:0.002404s ]
select * from pdf where partno='2800913' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800913' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64542029 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64542029 ORDER BY `minOrder` ASC [ RunTime:0.005246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64542029 ORDER BY `unit` DESC [ RunTime:0.010565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64542029 LIMIT 2 [ RunTime:0.003721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64542029 ORDER BY `minOrder` ASC [ RunTime:0.002802s ]
select * from pdf where partno='2800983' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800983' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64542028 LIMIT 5 [ RunTime:0.001982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64542028 ORDER BY `minOrder` ASC [ RunTime:0.016470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64542028 ORDER BY `unit` DESC [ RunTime:0.001800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64542028 LIMIT 2 [ RunTime:0.001290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64542028 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
select * from pdf where partno='2800981' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800981' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64542006 LIMIT 5 [ RunTime:0.016218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64542006 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64542006 ORDER BY `unit` DESC [ RunTime:0.002848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64542006 LIMIT 2 [ RunTime:0.008153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64542006 ORDER BY `minOrder` ASC [ RunTime:0.009422s ]
select * from pdf where partno='2800994' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2800994' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009393s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017648s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006320s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001012s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001012s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000960s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001704s ]
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 '28009%' OR `brand` LIKE '28009%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001400s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '28009%' OR `brand` LIKE '28009%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008064s ]