SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001736s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032800s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516544 LIMIT 5 [ RunTime:0.040150s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516544 ORDER BY `minOrder` ASC [ RunTime:0.076425s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.021816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516544 ORDER BY `unit` DESC [ RunTime:0.043161s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516544 LIMIT 2 [ RunTime:0.018526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516544 ORDER BY `minOrder` ASC [ RunTime:0.069079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516593 LIMIT 5 [ RunTime:0.027191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516593 ORDER BY `minOrder` ASC [ RunTime:0.057012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516593 ORDER BY `unit` DESC [ RunTime:0.016658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516593 LIMIT 2 [ RunTime:0.058611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516593 ORDER BY `minOrder` ASC [ RunTime:0.046604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516592 LIMIT 5 [ RunTime:0.091142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516592 ORDER BY `minOrder` ASC [ RunTime:0.064855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516592 ORDER BY `unit` DESC [ RunTime:0.043055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516592 LIMIT 2 [ RunTime:0.054448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516592 ORDER BY `minOrder` ASC [ RunTime:0.070672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516582 LIMIT 5 [ RunTime:0.027944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516582 ORDER BY `minOrder` ASC [ RunTime:0.066584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516582 ORDER BY `unit` DESC [ RunTime:0.022305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516582 LIMIT 2 [ RunTime:0.038557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516582 ORDER BY `minOrder` ASC [ RunTime:0.029039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591549 LIMIT 5 [ RunTime:0.019129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591549 ORDER BY `minOrder` ASC [ RunTime:0.035615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591549 ORDER BY `unit` DESC [ RunTime:0.020499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591549 LIMIT 2 [ RunTime:0.020612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591549 ORDER BY `minOrder` ASC [ RunTime:0.008915s ]
select * from pdf where partno='6331-0-00-15-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.047938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13337764 LIMIT 5 [ RunTime:0.036464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13337764 ORDER BY `minOrder` ASC [ RunTime:0.034519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13337764 ORDER BY `unit` DESC [ RunTime:0.031781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13337764 LIMIT 2 [ RunTime:0.020374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13337764 ORDER BY `minOrder` ASC [ RunTime:0.006157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517317 LIMIT 5 [ RunTime:0.027672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517317 ORDER BY `minOrder` ASC [ RunTime:0.029700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517317 ORDER BY `unit` DESC [ RunTime:0.014198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517317 LIMIT 2 [ RunTime:0.003384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517317 ORDER BY `minOrder` ASC [ RunTime:0.012894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511698 LIMIT 5 [ RunTime:0.020597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511698 ORDER BY `minOrder` ASC [ RunTime:0.020771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12511698 ORDER BY `unit` DESC [ RunTime:0.013943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12511698 LIMIT 2 [ RunTime:0.011407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511698 ORDER BY `minOrder` ASC [ RunTime:0.001026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11413745 LIMIT 5 [ RunTime:0.006350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413745 ORDER BY `minOrder` ASC [ RunTime:0.013031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11413745 ORDER BY `unit` DESC [ RunTime:0.013743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11413745 LIMIT 2 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413745 ORDER BY `minOrder` ASC [ RunTime:0.005339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514159 LIMIT 5 [ RunTime:0.008688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514159 ORDER BY `minOrder` ASC [ RunTime:0.004822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514159 ORDER BY `unit` DESC [ RunTime:0.005337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514159 LIMIT 2 [ RunTime:0.005070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514159 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511349 LIMIT 5 [ RunTime:0.003793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511349 ORDER BY `minOrder` ASC [ RunTime:0.002885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12511349 ORDER BY `unit` DESC [ RunTime:0.004454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12511349 LIMIT 2 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511349 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159358 LIMIT 5 [ RunTime:0.001211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159358 ORDER BY `minOrder` ASC [ RunTime:0.004845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12159358 ORDER BY `unit` DESC [ RunTime:0.005062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12159358 LIMIT 2 [ RunTime:0.006872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159358 ORDER BY `minOrder` ASC [ RunTime:0.006816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178703 LIMIT 5 [ RunTime:0.004076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178703 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11178703 ORDER BY `unit` DESC [ RunTime:0.001778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11178703 LIMIT 2 [ RunTime:0.005793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178703 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592996 LIMIT 5 [ RunTime:0.001924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592996 ORDER BY `minOrder` ASC [ RunTime:0.013024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592996 ORDER BY `unit` DESC [ RunTime:0.001890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592996 LIMIT 2 [ RunTime:0.002500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592996 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585087 LIMIT 5 [ RunTime:0.004890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585087 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19585087 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19585087 LIMIT 2 [ RunTime:0.002883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585087 ORDER BY `minOrder` ASC [ RunTime:0.005934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265860 LIMIT 5 [ RunTime:0.004120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265860 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265860 ORDER BY `unit` DESC [ RunTime:0.000359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265860 LIMIT 2 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265860 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
select * from pdf where partno='6331' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394716 LIMIT 5 [ RunTime:0.006494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394716 ORDER BY `minOrder` ASC [ RunTime:0.001411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394716 ORDER BY `unit` DESC [ RunTime:0.003125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394716 LIMIT 2 [ RunTime:0.001379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394716 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394710 LIMIT 5 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394710 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394710 ORDER BY `unit` DESC [ RunTime:0.009888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394710 LIMIT 2 [ RunTime:0.004693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394710 ORDER BY `minOrder` ASC [ RunTime:0.003243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394709 LIMIT 5 [ RunTime:0.001353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394709 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394709 ORDER BY `unit` DESC [ RunTime:0.003974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394709 LIMIT 2 [ RunTime:0.007750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394709 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389629 LIMIT 5 [ RunTime:0.001231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389629 ORDER BY `minOrder` ASC [ RunTime:0.005032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389629 ORDER BY `unit` DESC [ RunTime:0.000401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389629 LIMIT 2 [ RunTime:0.002623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389629 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282122 LIMIT 5 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282122 ORDER BY `minOrder` ASC [ RunTime:0.003558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282122 ORDER BY `unit` DESC [ RunTime:0.001267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282122 LIMIT 2 [ RunTime:0.001429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282122 ORDER BY `minOrder` ASC [ RunTime:0.004261s ]
select * from pdf where partno='63316-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000830s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63316-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000917s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282122 AND `partno` = '63316-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086518 LIMIT 5 [ RunTime:0.003066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086518 ORDER BY `minOrder` ASC [ RunTime:0.007124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086518 ORDER BY `unit` DESC [ RunTime:0.002834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086518 LIMIT 2 [ RunTime:0.002804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086518 ORDER BY `minOrder` ASC [ RunTime:0.002047s ]
select * from pdf where partno='6331g7' and brandshort='anderson power products' limit 1 [ RunTime:0.004457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331g7' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.014190s ]
SELECT `id` FROM `stock` WHERE `id` <> 51086518 AND `partno` = '6331g7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.003983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53568294 [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263926 LIMIT 5 [ RunTime:0.000785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263926 ORDER BY `minOrder` ASC [ RunTime:0.006765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32263926 ORDER BY `unit` DESC [ RunTime:0.003127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32263926 LIMIT 2 [ RunTime:0.008048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263926 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='6331g10' and brandshort='anderson power products' limit 1 [ RunTime:0.000782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331g10' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.002131s ]
SELECT `id` FROM `stock` WHERE `id` <> 32263926 AND `partno` = '6331g10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.001876s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53818888 LIMIT 5 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818888 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53818888 ORDER BY `unit` DESC [ RunTime:0.005970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53818888 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818888 ORDER BY `minOrder` ASC [ RunTime:0.002110s ]
select * from pdf where partno='63316-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63316-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001826s ]
SELECT `id` FROM `stock` WHERE `id` <> 53818888 AND `partno` = '63316-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53818330 LIMIT 5 [ RunTime:0.000733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818330 ORDER BY `minOrder` ASC [ RunTime:0.004801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53818330 ORDER BY `unit` DESC [ RunTime:0.000672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53818330 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818330 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='63315-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63315-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000682s ]
SELECT `id` FROM `stock` WHERE `id` <> 53818330 AND `partno` = '63315-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516582 [ RunTime:0.001908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53817477 LIMIT 5 [ RunTime:0.001931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817477 ORDER BY `minOrder` ASC [ RunTime:0.001752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53817477 ORDER BY `unit` DESC [ RunTime:0.001033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53817477 LIMIT 2 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817477 ORDER BY `minOrder` ASC [ RunTime:0.002598s ]
select * from pdf where partno='63313-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63313-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005632s ]
SELECT `id` FROM `stock` WHERE `id` <> 53817477 AND `partno` = '63313-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516544 [ RunTime:0.003682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53818341 LIMIT 5 [ RunTime:0.003560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818341 ORDER BY `minOrder` ASC [ RunTime:0.005931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53818341 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53818341 LIMIT 2 [ RunTime:0.006794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818341 ORDER BY `minOrder` ASC [ RunTime:0.002303s ]
select * from pdf where partno='63316-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63316-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007198s ]
SELECT `id` FROM `stock` WHERE `id` <> 53818341 AND `partno` = '63316-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516593 [ RunTime:0.010317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53818345 LIMIT 5 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818345 ORDER BY `minOrder` ASC [ RunTime:0.000747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53818345 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53818345 LIMIT 2 [ RunTime:0.016929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818345 ORDER BY `minOrder` ASC [ RunTime:0.002376s ]
select * from pdf where partno='63316-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63316-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010050s ]
SELECT `id` FROM `stock` WHERE `id` <> 53818345 AND `partno` = '63316-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516592 [ RunTime:0.000773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53492444 LIMIT 5 [ RunTime:0.001626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492444 ORDER BY `minOrder` ASC [ RunTime:0.005994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53492444 ORDER BY `unit` DESC [ RunTime:0.005686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53492444 LIMIT 2 [ RunTime:0.004528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492444 ORDER BY `minOrder` ASC [ RunTime:0.002132s ]
select * from pdf where partno='6331-0-00-15-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.002494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331-0-00-15-00-00-08-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001082s ]
SELECT `id` FROM `stock` WHERE `id` <> 53492444 AND `partno` = '6331-0-00-15-00-00-08-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.010098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591549 [ RunTime:0.010941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49174619 LIMIT 5 [ RunTime:0.008366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174619 ORDER BY `minOrder` ASC [ RunTime:0.002344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49174619 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49174619 LIMIT 2 [ RunTime:0.004144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174619 ORDER BY `minOrder` ASC [ RunTime:0.002403s ]
select * from pdf where partno='6331 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331 SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000404s ]
SELECT `id` FROM `stock` WHERE `id` <> 49174619 AND `partno` = '6331 SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389629 [ RunTime:0.001284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36378323 LIMIT 5 [ RunTime:0.002391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378323 ORDER BY `minOrder` ASC [ RunTime:0.000990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36378323 ORDER BY `unit` DESC [ RunTime:0.000718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36378323 LIMIT 2 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378323 ORDER BY `minOrder` ASC [ RunTime:0.004691s ]
select * from pdf where partno='6331 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331 SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000287s ]
SELECT `id` FROM `stock` WHERE `id` <> 36378323 AND `partno` = '6331 SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389629 [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53567990 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53567990 ORDER BY `minOrder` ASC [ RunTime:0.006513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53567990 ORDER BY `unit` DESC [ RunTime:0.005763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53567990 LIMIT 2 [ RunTime:0.004443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53567990 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='6331G2' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.000834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331G2' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.001648s ]
SELECT `id` FROM `stock` WHERE `id` <> 53567990 AND `partno` = '6331G2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.018554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11413745 [ RunTime:0.013262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50237587 LIMIT 5 [ RunTime:0.008291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50237587 ORDER BY `minOrder` ASC [ RunTime:0.006848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50237587 ORDER BY `unit` DESC [ RunTime:0.004348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50237587 LIMIT 2 [ RunTime:0.001721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50237587 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='6331' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000447s ]
SELECT `id` FROM `stock` WHERE `id` <> 50237587 AND `partno` = '6331' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.007525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265860 [ RunTime:0.002160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53567986 LIMIT 5 [ RunTime:0.003137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53567986 ORDER BY `minOrder` ASC [ RunTime:0.006180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53567986 ORDER BY `unit` DESC [ RunTime:0.000711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53567986 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53567986 ORDER BY `minOrder` ASC [ RunTime:0.006700s ]
select * from pdf where partno='6331G1' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.001371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331G1' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.011451s ]
SELECT `id` FROM `stock` WHERE `id` <> 53567986 AND `partno` = '6331G1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.010878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53568294 LIMIT 5 [ RunTime:0.020757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53568294 ORDER BY `minOrder` ASC [ RunTime:0.013038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53568294 ORDER BY `unit` DESC [ RunTime:0.001640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53568294 LIMIT 2 [ RunTime:0.007828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53568294 ORDER BY `minOrder` ASC [ RunTime:0.004060s ]
select * from pdf where partno='6331G7' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.005346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331G7' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.006477s ]
SELECT `id` FROM `stock` WHERE `id` <> 53568294 AND `partno` = '6331G7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.011341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53568296 LIMIT 5 [ RunTime:0.015515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53568296 ORDER BY `minOrder` ASC [ RunTime:0.012727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53568296 ORDER BY `unit` DESC [ RunTime:0.014298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53568296 LIMIT 2 [ RunTime:0.032508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53568296 ORDER BY `minOrder` ASC [ RunTime:0.005270s ]
select * from pdf where partno='6331G6' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.057979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331G6' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.018714s ]
SELECT `id` FROM `stock` WHERE `id` <> 53568296 AND `partno` = '6331G6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.038698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511697 [ RunTime:0.016945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53568295 LIMIT 5 [ RunTime:0.006866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53568295 ORDER BY `minOrder` ASC [ RunTime:0.002367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53568295 ORDER BY `unit` DESC [ RunTime:0.008413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53568295 LIMIT 2 [ RunTime:0.018456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53568295 ORDER BY `minOrder` ASC [ RunTime:0.008594s ]
select * from pdf where partno='6331G5' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.015114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331G5' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.019501s ]
SELECT `id` FROM `stock` WHERE `id` <> 53568295 AND `partno` = '6331G5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.012891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511349 [ RunTime:0.055827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53568297 LIMIT 5 [ RunTime:0.024556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53568297 ORDER BY `minOrder` ASC [ RunTime:0.007922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53568297 ORDER BY `unit` DESC [ RunTime:0.004676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53568297 LIMIT 2 [ RunTime:0.010973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53568297 ORDER BY `minOrder` ASC [ RunTime:0.004092s ]
select * from pdf where partno='6331G4' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.006220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331G4' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.021009s ]
SELECT `id` FROM `stock` WHERE `id` <> 53568297 AND `partno` = '6331G4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.027991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511698 [ RunTime:0.020458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36382107 LIMIT 5 [ RunTime:0.008754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36382107 ORDER BY `minOrder` ASC [ RunTime:0.021567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36382107 ORDER BY `unit` DESC [ RunTime:0.016920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36382107 LIMIT 2 [ RunTime:0.007622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36382107 ORDER BY `minOrder` ASC [ RunTime:0.003834s ]
select * from pdf where partno='6331 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.007640s ]
SELECT `id` FROM `stock` WHERE `id` <> 36382107 AND `partno` = '6331 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.016864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514159 [ RunTime:0.012840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49178373 LIMIT 5 [ RunTime:0.010588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49178373 ORDER BY `minOrder` ASC [ RunTime:0.008165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49178373 ORDER BY `unit` DESC [ RunTime:0.011855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49178373 LIMIT 2 [ RunTime:0.021385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49178373 ORDER BY `minOrder` ASC [ RunTime:0.008361s ]
select * from pdf where partno='6331 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6331 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000402s ]
SELECT `id` FROM `stock` WHERE `id` <> 49178373 AND `partno` = '6331 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514159 [ RunTime:0.004987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51704708 LIMIT 5 [ RunTime:0.001912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51704708 ORDER BY `minOrder` ASC [ RunTime:0.001867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51704708 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51704708 LIMIT 2 [ RunTime:0.002164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51704708 ORDER BY `minOrder` ASC [ RunTime:0.005851s ]
select * from pdf where partno='63318' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.001465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63318' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.007232s ]
SELECT `id` FROM `stock` WHERE `id` <> 51704708 AND `partno` = '63318' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.000890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159358 [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51704862 LIMIT 5 [ RunTime:0.007453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51704862 ORDER BY `minOrder` ASC [ RunTime:0.001835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51704862 ORDER BY `unit` DESC [ RunTime:0.011773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51704862 LIMIT 2 [ RunTime:0.002878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51704862 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='63314' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.007352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63314' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001606s ]
SELECT `id` FROM `stock` WHERE `id` <> 51704862 AND `partno` = '63314' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178703 [ RunTime:0.000650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53821176 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53821176 ORDER BY `minOrder` ASC [ RunTime:0.008484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53821176 ORDER BY `unit` DESC [ RunTime:0.004990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53821176 LIMIT 2 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53821176 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='63314-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '63314-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000892s ]
SELECT `id` FROM `stock` WHERE `id` <> 53821176 AND `partno` = '63314-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517317 [ RunTime:0.000801s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006135s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007388s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010211s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009825s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010163s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005434s ]
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 '6331%' OR `brand` LIKE '6331%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002991s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6331%' OR `brand` LIKE '6331%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004909s ]