SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007143s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024215s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.030218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065461 LIMIT 5 [ RunTime:0.072553s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065461 ORDER BY `minOrder` ASC [ RunTime:0.033000s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065461 ORDER BY `unit` DESC [ RunTime:0.015520s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065461 LIMIT 2 [ RunTime:0.017598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065461 ORDER BY `minOrder` ASC [ RunTime:0.020535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562275 LIMIT 5 [ RunTime:0.059526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562275 ORDER BY `minOrder` ASC [ RunTime:0.061795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562275 ORDER BY `unit` DESC [ RunTime:0.042544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562275 LIMIT 2 [ RunTime:0.050301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562275 ORDER BY `minOrder` ASC [ RunTime:0.055905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19811479 LIMIT 5 [ RunTime:0.040749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811479 ORDER BY `minOrder` ASC [ RunTime:0.018433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19811479 ORDER BY `unit` DESC [ RunTime:0.142736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19811479 LIMIT 2 [ RunTime:0.016535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811479 ORDER BY `minOrder` ASC [ RunTime:0.018911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835878 LIMIT 5 [ RunTime:0.034816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835878 ORDER BY `minOrder` ASC [ RunTime:0.019672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835878 ORDER BY `unit` DESC [ RunTime:0.023199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835878 LIMIT 2 [ RunTime:0.026271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835878 ORDER BY `minOrder` ASC [ RunTime:0.013559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18783000 LIMIT 5 [ RunTime:0.016769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18783000 ORDER BY `minOrder` ASC [ RunTime:0.023372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18783000 ORDER BY `unit` DESC [ RunTime:0.022116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18783000 LIMIT 2 [ RunTime:0.026968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18783000 ORDER BY `minOrder` ASC [ RunTime:0.004878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16201191 LIMIT 5 [ RunTime:0.023456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16201191 ORDER BY `minOrder` ASC [ RunTime:0.016508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16201191 ORDER BY `unit` DESC [ RunTime:0.022491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16201191 LIMIT 2 [ RunTime:0.004995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16201191 ORDER BY `minOrder` ASC [ RunTime:0.003271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12729277 LIMIT 5 [ RunTime:0.010473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12729277 ORDER BY `minOrder` ASC [ RunTime:0.003833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12729277 ORDER BY `unit` DESC [ RunTime:0.014435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12729277 LIMIT 2 [ RunTime:0.010961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12729277 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12723838 LIMIT 5 [ RunTime:0.014388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12723838 ORDER BY `minOrder` ASC [ RunTime:0.003451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12723838 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12723838 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12723838 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11561510 LIMIT 5 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11561510 ORDER BY `minOrder` ASC [ RunTime:0.003125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11561510 ORDER BY `unit` DESC [ RunTime:0.003962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11561510 LIMIT 2 [ RunTime:0.008195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11561510 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11437164 LIMIT 5 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11437164 ORDER BY `minOrder` ASC [ RunTime:0.002511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11437164 ORDER BY `unit` DESC [ RunTime:0.000594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11437164 LIMIT 2 [ RunTime:0.002636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11437164 ORDER BY `minOrder` ASC [ RunTime:0.005099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11437163 LIMIT 5 [ RunTime:0.003693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11437163 ORDER BY `minOrder` ASC [ RunTime:0.003730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11437163 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11437163 LIMIT 2 [ RunTime:0.002686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11437163 ORDER BY `minOrder` ASC [ RunTime:0.002812s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001450s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57739727 LIMIT 5 [ RunTime:0.002141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739727 ORDER BY `minOrder` ASC [ RunTime:0.007733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57739727 ORDER BY `unit` DESC [ RunTime:0.002639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57739727 LIMIT 2 [ RunTime:0.005663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739727 ORDER BY `minOrder` ASC [ RunTime:0.005872s ]
select * from pdf where partno='10257CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001882s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10257CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001019s ]
SELECT `id` FROM `stock` WHERE `id` <> 57739727 AND `partno` = '10257CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.003473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065461 [ RunTime:0.001523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60470472 LIMIT 5 [ RunTime:0.003229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470472 ORDER BY `minOrder` ASC [ RunTime:0.002049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60470472 ORDER BY `unit` DESC [ RunTime:0.001353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60470472 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470472 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='1025700000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025700000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002036s ]
SELECT `id` FROM `stock` WHERE `id` <> 60470472 AND `partno` = '1025700000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562275 [ RunTime:0.003229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60583771 LIMIT 5 [ RunTime:0.002915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60583771 ORDER BY `minOrder` ASC [ RunTime:0.003547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60583771 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60583771 LIMIT 2 [ RunTime:0.001765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60583771 ORDER BY `minOrder` ASC [ RunTime:0.003454s ]
select * from pdf where partno='10257.4' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.001213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10257.4' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000972s ]
SELECT `id` FROM `stock` WHERE `id` <> 60583771 AND `partno` = '10257.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.006755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11437164 [ RunTime:0.002888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60583770 LIMIT 5 [ RunTime:0.005848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60583770 ORDER BY `minOrder` ASC [ RunTime:0.000852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60583770 ORDER BY `unit` DESC [ RunTime:0.001413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60583770 LIMIT 2 [ RunTime:0.007600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60583770 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='10257.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10257.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.003295s ]
SELECT `id` FROM `stock` WHERE `id` <> 60583770 AND `partno` = '10257.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.003660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11437163 [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59681700 LIMIT 5 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59681700 ORDER BY `minOrder` ASC [ RunTime:0.005146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59681700 ORDER BY `unit` DESC [ RunTime:0.004131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59681700 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59681700 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='102570-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102570-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000432s ]
SELECT `id` FROM `stock` WHERE `id` <> 59681700 AND `partno` = '102570-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19811479 [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59645129 LIMIT 5 [ RunTime:0.004621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59645129 ORDER BY `minOrder` ASC [ RunTime:0.007021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59645129 ORDER BY `unit` DESC [ RunTime:0.004978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59645129 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59645129 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='102570-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102570-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010119s ]
SELECT `id` FROM `stock` WHERE `id` <> 59645129 AND `partno` = '102570-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16201191 [ RunTime:0.008819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59626159 LIMIT 5 [ RunTime:0.010939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59626159 ORDER BY `minOrder` ASC [ RunTime:0.007483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59626159 ORDER BY `unit` DESC [ RunTime:0.005922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59626159 LIMIT 2 [ RunTime:0.018441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59626159 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
select * from pdf where partno='102570-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102570-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005028s ]
SELECT `id` FROM `stock` WHERE `id` <> 59626159 AND `partno` = '102570-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.014284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12729277 [ RunTime:0.002401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59620531 LIMIT 5 [ RunTime:0.003394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59620531 ORDER BY `minOrder` ASC [ RunTime:0.008351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59620531 ORDER BY `unit` DESC [ RunTime:0.002581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59620531 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59620531 ORDER BY `minOrder` ASC [ RunTime:0.008747s ]
select * from pdf where partno='102570-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102570-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002650s ]
SELECT `id` FROM `stock` WHERE `id` <> 59620531 AND `partno` = '102570-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11561510 [ RunTime:0.004841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59616810 LIMIT 5 [ RunTime:0.016005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59616810 ORDER BY `minOrder` ASC [ RunTime:0.006824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59616810 ORDER BY `unit` DESC [ RunTime:0.009928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59616810 LIMIT 2 [ RunTime:0.023132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59616810 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='102570-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102570-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003008s ]
SELECT `id` FROM `stock` WHERE `id` <> 59616810 AND `partno` = '102570-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12723838 [ RunTime:0.003491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57646713 LIMIT 5 [ RunTime:0.002589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57646713 ORDER BY `minOrder` ASC [ RunTime:0.005324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57646713 ORDER BY `unit` DESC [ RunTime:0.008259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57646713 LIMIT 2 [ RunTime:0.002113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57646713 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='1025785' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025785' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015878s ]
SELECT `id` FROM `stock` WHERE `id` <> 57646713 AND `partno` = '1025785' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835878 [ RunTime:0.002128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56569873 LIMIT 5 [ RunTime:0.003000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56569873 ORDER BY `minOrder` ASC [ RunTime:0.007013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56569873 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56569873 LIMIT 2 [ RunTime:0.006317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56569873 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='10257F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.011176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10257F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.008454s ]
SELECT `id` FROM `stock` WHERE `id` <> 56569873 AND `partno` = '10257F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56568858 LIMIT 5 [ RunTime:0.001228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56568858 ORDER BY `minOrder` ASC [ RunTime:0.009520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56568858 ORDER BY `unit` DESC [ RunTime:0.003264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56568858 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56568858 ORDER BY `minOrder` ASC [ RunTime:0.002973s ]
select * from pdf where partno='10257' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10257' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.005762s ]
SELECT `id` FROM `stock` WHERE `id` <> 56568858 AND `partno` = '10257' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.005440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56536215 LIMIT 5 [ RunTime:0.008712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56536215 ORDER BY `minOrder` ASC [ RunTime:0.008265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56536215 ORDER BY `unit` DESC [ RunTime:0.007513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56536215 LIMIT 2 [ RunTime:0.006057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56536215 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='1025709' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025709' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005917s ]
SELECT `id` FROM `stock` WHERE `id` <> 56536215 AND `partno` = '1025709' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18783000 [ RunTime:0.006036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32464444 LIMIT 5 [ RunTime:0.002008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32464444 ORDER BY `minOrder` ASC [ RunTime:0.003542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32464444 ORDER BY `unit` DESC [ RunTime:0.000533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32464444 LIMIT 2 [ RunTime:0.002991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32464444 ORDER BY `minOrder` ASC [ RunTime:0.006007s ]
select * from pdf where partno='10257-8' and brandshort='Omega' limit 1 [ RunTime:0.017838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10257-8' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.012205s ]
SELECT `id` FROM `stock` WHERE `id` <> 32464444 AND `partno` = '10257-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.026492s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016248s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021099s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020487s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016184s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029598s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003932s ]
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 '10257%' OR `brand` LIKE '10257%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015390s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10257%' OR `brand` LIKE '10257%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015739s ]