SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002837s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016394s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510344 LIMIT 5 [ RunTime:0.044949s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510344 ORDER BY `minOrder` ASC [ RunTime:0.017657s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19510344 ORDER BY `unit` DESC [ RunTime:0.025766s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19510344 LIMIT 2 [ RunTime:0.017728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510344 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510167 LIMIT 5 [ RunTime:0.031912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510167 ORDER BY `minOrder` ASC [ RunTime:0.038038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19510167 ORDER BY `unit` DESC [ RunTime:0.108063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19510167 LIMIT 2 [ RunTime:0.088892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510167 ORDER BY `minOrder` ASC [ RunTime:0.011210s ]
select * from pdf where partno='2513254510291' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.040363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510150 LIMIT 5 [ RunTime:0.032367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510150 ORDER BY `minOrder` ASC [ RunTime:0.065539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19510150 ORDER BY `unit` DESC [ RunTime:0.044222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19510150 LIMIT 2 [ RunTime:0.041338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510150 ORDER BY `minOrder` ASC [ RunTime:0.017687s ]
select * from pdf where partno='2513254510491' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.058040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510149 LIMIT 5 [ RunTime:0.023708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510149 ORDER BY `minOrder` ASC [ RunTime:0.051986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19510149 ORDER BY `unit` DESC [ RunTime:0.056345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19510149 LIMIT 2 [ RunTime:0.052061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510149 ORDER BY `minOrder` ASC [ RunTime:0.009776s ]
select * from pdf where partno='2513254510391' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.030501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11958 LIMIT 5 [ RunTime:0.019309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11958 ORDER BY `minOrder` ASC [ RunTime:0.044619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11958 ORDER BY `unit` DESC [ RunTime:0.037998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11958 LIMIT 2 [ RunTime:0.048767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11958 ORDER BY `minOrder` ASC [ RunTime:0.016636s ]
select * from pdf where partno='2513254510291' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.019768s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510291' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.014423s ]
SELECT `id` FROM `stock` WHERE `id` <> 11958 AND `partno` = '2513254510291' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.040462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510167 [ RunTime:0.009907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510345 LIMIT 5 [ RunTime:0.005665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510345 ORDER BY `minOrder` ASC [ RunTime:0.019400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19510345 ORDER BY `unit` DESC [ RunTime:0.010692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19510345 LIMIT 2 [ RunTime:0.015725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510345 ORDER BY `minOrder` ASC [ RunTime:0.020335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510155 LIMIT 5 [ RunTime:0.021333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510155 ORDER BY `minOrder` ASC [ RunTime:0.004817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19510155 ORDER BY `unit` DESC [ RunTime:0.000538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19510155 LIMIT 2 [ RunTime:0.028371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510155 ORDER BY `minOrder` ASC [ RunTime:0.017495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510151 LIMIT 5 [ RunTime:0.013372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510151 ORDER BY `minOrder` ASC [ RunTime:0.017289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19510151 ORDER BY `unit` DESC [ RunTime:0.007959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19510151 LIMIT 2 [ RunTime:0.037142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510151 ORDER BY `minOrder` ASC [ RunTime:0.021121s ]
select * from pdf where partno='2513254510191' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15426228 LIMIT 5 [ RunTime:0.020484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15426228 ORDER BY `minOrder` ASC [ RunTime:0.012667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15426228 ORDER BY `unit` DESC [ RunTime:0.004026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15426228 LIMIT 2 [ RunTime:0.017350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15426228 ORDER BY `minOrder` ASC [ RunTime:0.012984s ]
select * from pdf where partno='2513254510091' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.028281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422801 LIMIT 5 [ RunTime:0.022757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422801 ORDER BY `minOrder` ASC [ RunTime:0.016562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422801 ORDER BY `unit` DESC [ RunTime:0.007248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422801 LIMIT 2 [ RunTime:0.029548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422801 ORDER BY `minOrder` ASC [ RunTime:0.003632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385898 LIMIT 5 [ RunTime:0.053244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385898 ORDER BY `minOrder` ASC [ RunTime:0.012065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385898 ORDER BY `unit` DESC [ RunTime:0.054002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385898 LIMIT 2 [ RunTime:0.071523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385898 ORDER BY `minOrder` ASC [ RunTime:0.022058s ]
select * from pdf where partno='25132 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.026938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506346 LIMIT 5 [ RunTime:0.048695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506346 ORDER BY `minOrder` ASC [ RunTime:0.058773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13506346 ORDER BY `unit` DESC [ RunTime:0.009856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13506346 LIMIT 2 [ RunTime:0.019978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506346 ORDER BY `minOrder` ASC [ RunTime:0.005483s ]
select * from pdf where partno='25132 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506345 LIMIT 5 [ RunTime:0.053828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506345 ORDER BY `minOrder` ASC [ RunTime:0.009630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13506345 ORDER BY `unit` DESC [ RunTime:0.006292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13506345 LIMIT 2 [ RunTime:0.018965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506345 ORDER BY `minOrder` ASC [ RunTime:0.032088s ]
select * from pdf where partno='25132 BL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.023865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506344 LIMIT 5 [ RunTime:0.022677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506344 ORDER BY `minOrder` ASC [ RunTime:0.018960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13506344 ORDER BY `unit` DESC [ RunTime:0.028116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13506344 LIMIT 2 [ RunTime:0.066711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506344 ORDER BY `minOrder` ASC [ RunTime:0.027744s ]
select * from pdf where partno='25132 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.015978s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51104193 LIMIT 5 [ RunTime:0.018228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104193 ORDER BY `minOrder` ASC [ RunTime:0.102188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51104193 ORDER BY `unit` DESC [ RunTime:0.042745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51104193 LIMIT 2 [ RunTime:0.027026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104193 ORDER BY `minOrder` ASC [ RunTime:0.021063s ]
select * from pdf where partno='2513254510492' and brandshort='wurth elektronik' limit 1 [ RunTime:0.052669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510492' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.024884s ]
SELECT `id` FROM `stock` WHERE `id` <> 51104193 AND `partno` = '2513254510492' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.027065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510345 [ RunTime:0.007962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51104702 LIMIT 5 [ RunTime:0.010902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104702 ORDER BY `minOrder` ASC [ RunTime:0.007784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51104702 ORDER BY `unit` DESC [ RunTime:0.028765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51104702 LIMIT 2 [ RunTime:0.012753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51104702 ORDER BY `minOrder` ASC [ RunTime:0.005326s ]
select * from pdf where partno='2513254510091' and brandshort='wurth elektronik' limit 1 [ RunTime:0.007655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510091' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.024684s ]
SELECT `id` FROM `stock` WHERE `id` <> 51104702 AND `partno` = '2513254510091' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.013707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15426228 [ RunTime:0.012783s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238907 LIMIT 5 [ RunTime:0.013373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238907 ORDER BY `minOrder` ASC [ RunTime:0.015962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238907 ORDER BY `unit` DESC [ RunTime:0.006379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238907 LIMIT 2 [ RunTime:0.002051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238907 ORDER BY `minOrder` ASC [ RunTime:0.002896s ]
select * from pdf where partno='2513254510492' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.010520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510492' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003984s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238907 AND `partno` = '2513254510492' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.015711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510345 [ RunTime:0.013128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238906 LIMIT 5 [ RunTime:0.009153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238906 ORDER BY `minOrder` ASC [ RunTime:0.002469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238906 ORDER BY `unit` DESC [ RunTime:0.000978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238906 LIMIT 2 [ RunTime:0.004073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238906 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='2513254510192' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510192' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002765s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238906 AND `partno` = '2513254510192' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.011529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510344 [ RunTime:0.008266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238645 LIMIT 5 [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238645 ORDER BY `minOrder` ASC [ RunTime:0.001969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238645 ORDER BY `unit` DESC [ RunTime:0.001644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238645 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238645 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='2513254510191' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510191' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004017s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238645 AND `partno` = '2513254510191' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510151 [ RunTime:0.000703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238644 LIMIT 5 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238644 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238644 ORDER BY `unit` DESC [ RunTime:0.000554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238644 LIMIT 2 [ RunTime:0.003822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238644 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='2513254510091' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510091' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001201s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238644 AND `partno` = '2513254510091' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15426228 [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238648 LIMIT 5 [ RunTime:0.000919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238648 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238648 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238648 LIMIT 2 [ RunTime:0.003042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238648 ORDER BY `minOrder` ASC [ RunTime:0.006435s ]
select * from pdf where partno='2513254510291' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510291' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001134s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238648 AND `partno` = '2513254510291' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11958 [ RunTime:0.002896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510167 [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238651 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238651 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238651 ORDER BY `unit` DESC [ RunTime:0.000514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238651 LIMIT 2 [ RunTime:0.002751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238651 ORDER BY `minOrder` ASC [ RunTime:0.006480s ]
select * from pdf where partno='2513254515491' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254515491' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.016424s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238651 AND `partno` = '2513254515491' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.004398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510155 [ RunTime:0.003955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238650 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238650 ORDER BY `minOrder` ASC [ RunTime:0.003937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238650 ORDER BY `unit` DESC [ RunTime:0.003074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238650 LIMIT 2 [ RunTime:0.001122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238650 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='2513254510491' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510491' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005278s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238650 AND `partno` = '2513254510491' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.011976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510150 [ RunTime:0.017316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57238649 LIMIT 5 [ RunTime:0.002008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238649 ORDER BY `minOrder` ASC [ RunTime:0.002984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57238649 ORDER BY `unit` DESC [ RunTime:0.002285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57238649 LIMIT 2 [ RunTime:0.002410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57238649 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='2513254510391' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2513254510391' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000514s ]
SELECT `id` FROM `stock` WHERE `id` <> 57238649 AND `partno` = '2513254510391' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510149 [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50707132 LIMIT 5 [ RunTime:0.004882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50707132 ORDER BY `minOrder` ASC [ RunTime:0.003440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50707132 ORDER BY `unit` DESC [ RunTime:0.014502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50707132 LIMIT 2 [ RunTime:0.002327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50707132 ORDER BY `minOrder` ASC [ RunTime:0.002635s ]
select * from pdf where partno='25132' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25132' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006578s ]
SELECT `id` FROM `stock` WHERE `id` <> 50707132 AND `partno` = '25132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.006067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422801 [ RunTime:0.012234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38092890 LIMIT 5 [ RunTime:0.011187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38092890 ORDER BY `minOrder` ASC [ RunTime:0.015368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38092890 ORDER BY `unit` DESC [ RunTime:0.006451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38092890 LIMIT 2 [ RunTime:0.008173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38092890 ORDER BY `minOrder` ASC [ RunTime:0.008539s ]
select * from pdf where partno='25132' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25132' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000500s ]
SELECT `id` FROM `stock` WHERE `id` <> 38092890 AND `partno` = '25132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422801 [ RunTime:0.000422s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005142s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016276s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019834s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007016s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010632s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014877s ]
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 '25132%' OR `brand` LIKE '25132%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013700s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25132%' OR `brand` LIKE '25132%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008394s ]