SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002412s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022722s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19246880 LIMIT 5 [ RunTime:0.025035s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19246880 ORDER BY `minOrder` ASC [ RunTime:0.006094s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.025687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19246880 ORDER BY `unit` DESC [ RunTime:0.076619s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.023377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19246880 LIMIT 2 [ RunTime:0.034185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19246880 ORDER BY `minOrder` ASC [ RunTime:0.014546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15332121 LIMIT 5 [ RunTime:0.082568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15332121 ORDER BY `minOrder` ASC [ RunTime:0.050954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15332121 ORDER BY `unit` DESC [ RunTime:0.098048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15332121 LIMIT 2 [ RunTime:0.048506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15332121 ORDER BY `minOrder` ASC [ RunTime:0.071455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14433391 LIMIT 5 [ RunTime:0.046537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14433391 ORDER BY `minOrder` ASC [ RunTime:0.026579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14433391 ORDER BY `unit` DESC [ RunTime:0.021436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14433391 LIMIT 2 [ RunTime:0.025773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14433391 ORDER BY `minOrder` ASC [ RunTime:0.006377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19201926 LIMIT 5 [ RunTime:0.016857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19201926 ORDER BY `minOrder` ASC [ RunTime:0.036990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19201926 ORDER BY `unit` DESC [ RunTime:0.023236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19201926 LIMIT 2 [ RunTime:0.101495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19201926 ORDER BY `minOrder` ASC [ RunTime:0.016577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19201883 LIMIT 5 [ RunTime:0.027861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19201883 ORDER BY `minOrder` ASC [ RunTime:0.040436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19201883 ORDER BY `unit` DESC [ RunTime:0.024248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19201883 LIMIT 2 [ RunTime:0.057184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19201883 ORDER BY `minOrder` ASC [ RunTime:0.029284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879609 LIMIT 5 [ RunTime:0.028785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879609 ORDER BY `minOrder` ASC [ RunTime:0.018727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12879609 ORDER BY `unit` DESC [ RunTime:0.030471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12879609 LIMIT 2 [ RunTime:0.013803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879609 ORDER BY `minOrder` ASC [ RunTime:0.013049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14434277 LIMIT 5 [ RunTime:0.018470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14434277 ORDER BY `minOrder` ASC [ RunTime:0.019874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14434277 ORDER BY `unit` DESC [ RunTime:0.002967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14434277 LIMIT 2 [ RunTime:0.033548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14434277 ORDER BY `minOrder` ASC [ RunTime:0.015909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14434271 LIMIT 5 [ RunTime:0.021861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14434271 ORDER BY `minOrder` ASC [ RunTime:0.021338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14434271 ORDER BY `unit` DESC [ RunTime:0.049710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14434271 LIMIT 2 [ RunTime:0.016114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14434271 ORDER BY `minOrder` ASC [ RunTime:0.004455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3481 LIMIT 5 [ RunTime:0.031748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3481 ORDER BY `minOrder` ASC [ RunTime:0.055926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3481 ORDER BY `unit` DESC [ RunTime:0.053052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3481 LIMIT 2 [ RunTime:0.015576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3481 ORDER BY `minOrder` ASC [ RunTime:0.014951s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67492-1420' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.058379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371949 LIMIT 5 [ RunTime:0.032348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371949 ORDER BY `minOrder` ASC [ RunTime:0.027564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17371949 ORDER BY `unit` DESC [ RunTime:0.011406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17371949 LIMIT 2 [ RunTime:0.026572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371949 ORDER BY `minOrder` ASC [ RunTime:0.014415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19023901 LIMIT 5 [ RunTime:0.042188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19023901 ORDER BY `minOrder` ASC [ RunTime:0.041263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19023901 ORDER BY `unit` DESC [ RunTime:0.003014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19023901 LIMIT 2 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19023901 ORDER BY `minOrder` ASC [ RunTime:0.006982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880619 LIMIT 5 [ RunTime:0.013404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880619 ORDER BY `minOrder` ASC [ RunTime:0.047525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880619 ORDER BY `unit` DESC [ RunTime:0.031220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880619 LIMIT 2 [ RunTime:0.024512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880619 ORDER BY `minOrder` ASC [ RunTime:0.014114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880602 LIMIT 5 [ RunTime:0.003508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880602 ORDER BY `minOrder` ASC [ RunTime:0.009416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880602 ORDER BY `unit` DESC [ RunTime:0.008853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880602 LIMIT 2 [ RunTime:0.002025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880602 ORDER BY `minOrder` ASC [ RunTime:0.001902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588242 LIMIT 5 [ RunTime:0.025700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588242 ORDER BY `minOrder` ASC [ RunTime:0.014268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18588242 ORDER BY `unit` DESC [ RunTime:0.008419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18588242 LIMIT 2 [ RunTime:0.001405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588242 ORDER BY `minOrder` ASC [ RunTime:0.002830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14255078 LIMIT 5 [ RunTime:0.010134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14255078 ORDER BY `minOrder` ASC [ RunTime:0.005127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14255078 ORDER BY `unit` DESC [ RunTime:0.017809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14255078 LIMIT 2 [ RunTime:0.005418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14255078 ORDER BY `minOrder` ASC [ RunTime:0.002690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274840 LIMIT 5 [ RunTime:0.015266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274840 ORDER BY `minOrder` ASC [ RunTime:0.007859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274840 ORDER BY `unit` DESC [ RunTime:0.011574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274840 LIMIT 2 [ RunTime:0.021501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274840 ORDER BY `minOrder` ASC [ RunTime:0.016932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12873050 LIMIT 5 [ RunTime:0.006534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12873050 ORDER BY `minOrder` ASC [ RunTime:0.012767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12873050 ORDER BY `unit` DESC [ RunTime:0.015718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12873050 LIMIT 2 [ RunTime:0.004503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12873050 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034890 LIMIT 5 [ RunTime:0.015728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034890 ORDER BY `minOrder` ASC [ RunTime:0.018634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034890 ORDER BY `unit` DESC [ RunTime:0.022099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034890 LIMIT 2 [ RunTime:0.010569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034890 ORDER BY `minOrder` ASC [ RunTime:0.006411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032558 LIMIT 5 [ RunTime:0.036296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032558 ORDER BY `minOrder` ASC [ RunTime:0.031930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19032558 ORDER BY `unit` DESC [ RunTime:0.006032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19032558 LIMIT 2 [ RunTime:0.012444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032558 ORDER BY `minOrder` ASC [ RunTime:0.021494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276258 LIMIT 5 [ RunTime:0.009608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276258 ORDER BY `minOrder` ASC [ RunTime:0.043084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15276258 ORDER BY `unit` DESC [ RunTime:0.011311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15276258 LIMIT 2 [ RunTime:0.032570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276258 ORDER BY `minOrder` ASC [ RunTime:0.011353s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254560 LIMIT 5 [ RunTime:0.022523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254560 ORDER BY `minOrder` ASC [ RunTime:0.040835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254560 ORDER BY `unit` DESC [ RunTime:0.053938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254560 LIMIT 2 [ RunTime:0.041559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254560 ORDER BY `minOrder` ASC [ RunTime:0.018728s ]
select * from pdf where partno='67489-8002' and brandshort='molex' limit 1 [ RunTime:0.017132s ]
select foldpath,foldpath2,filename from pdf_file where id=1587272 limit 1 [ RunTime:0.014434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67489-8002' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.030565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32221396 LIMIT 5 [ RunTime:0.013476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221396 ORDER BY `minOrder` ASC [ RunTime:0.057190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32221396 ORDER BY `unit` DESC [ RunTime:0.016945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32221396 LIMIT 2 [ RunTime:0.029100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221396 ORDER BY `minOrder` ASC [ RunTime:0.030623s ]
select * from pdf where partno='67483-01-705 rc-37-2aa, 9vb ruby red' and brandshort='pactec' limit 1 [ RunTime:0.031856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67483-01-705 rc-37-2aa, 9vb ruby red' OR `brand` LIKE 'pactec%' ) ) LIMIT 1 [ RunTime:0.021374s ]
SELECT `id` FROM `stock` WHERE `id` <> 32221396 AND `partno` = '67483-01-705 rc-37-2aa, 9vb ruby red' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pactec%' ) [ RunTime:0.010623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085363 LIMIT 5 [ RunTime:0.032028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085363 ORDER BY `minOrder` ASC [ RunTime:0.038572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085363 ORDER BY `unit` DESC [ RunTime:0.014155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085363 LIMIT 2 [ RunTime:0.037426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085363 ORDER BY `minOrder` ASC [ RunTime:0.004592s ]
select * from pdf where partno='67443-1-7612' and brandshort='ebm-papst' limit 1 [ RunTime:0.004460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67443-1-7612' OR `brand` LIKE 'ebm-papst%' ) ) LIMIT 1 [ RunTime:0.008373s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085363 AND `partno` = '67443-1-7612' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.022836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32245763 LIMIT 5 [ RunTime:0.004024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245763 ORDER BY `minOrder` ASC [ RunTime:0.040954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32245763 ORDER BY `unit` DESC [ RunTime:0.020158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32245763 LIMIT 2 [ RunTime:0.024937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245763 ORDER BY `minOrder` ASC [ RunTime:0.019534s ]
select * from pdf where partno='674a91' and brandshort='amphenol pcb piezotronics' limit 1 [ RunTime:0.053996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '674a91' OR `brand` LIKE 'amphenol pcb piezotronics%' ) ) LIMIT 1 [ RunTime:0.034427s ]
SELECT `id` FROM `stock` WHERE `id` <> 32245763 AND `partno` = '674a91' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol pcb piezotronics%' ) [ RunTime:0.018097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14255078 [ RunTime:0.003812s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62419787 LIMIT 5 [ RunTime:0.014488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62419787 ORDER BY `minOrder` ASC [ RunTime:0.025820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62419787 ORDER BY `unit` DESC [ RunTime:0.035894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62419787 LIMIT 2 [ RunTime:0.042152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62419787 ORDER BY `minOrder` ASC [ RunTime:0.021001s ]
select * from pdf where partno='67400-185-EB' and brandshort='Inventus Power' limit 1 [ RunTime:0.023046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67400-185-EB' OR `brand` LIKE 'Inventus Power%' ) ) LIMIT 1 [ RunTime:0.020053s ]
SELECT `id` FROM `stock` WHERE `id` <> 62419787 AND `partno` = '67400-185-EB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%inventus power%' ) [ RunTime:0.021093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14433391 [ RunTime:0.023944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57042748 LIMIT 5 [ RunTime:0.013410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57042748 ORDER BY `minOrder` ASC [ RunTime:0.016486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57042748 ORDER BY `unit` DESC [ RunTime:0.020552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57042748 LIMIT 2 [ RunTime:0.009247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57042748 ORDER BY `minOrder` ASC [ RunTime:0.002704s ]
select * from pdf where partno='674R-01LF' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.017053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '674R-01LF' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.003508s ]
SELECT `id` FROM `stock` WHERE `id` <> 57042748 AND `partno` = '674R-01LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.011056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19246880 [ RunTime:0.003404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56995539 LIMIT 5 [ RunTime:0.006382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56995539 ORDER BY `minOrder` ASC [ RunTime:0.018445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56995539 ORDER BY `unit` DESC [ RunTime:0.021957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56995539 LIMIT 2 [ RunTime:0.013470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56995539 ORDER BY `minOrder` ASC [ RunTime:0.004894s ]
select * from pdf where partno='67413AJ' and brandshort='Advanced Micro Devices' limit 1 [ RunTime:0.017342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67413AJ' OR `brand` LIKE 'Advanced Micro Devices%' ) ) LIMIT 1 [ RunTime:0.029319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56995509 LIMIT 5 [ RunTime:0.009635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56995509 ORDER BY `minOrder` ASC [ RunTime:0.017188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56995509 ORDER BY `unit` DESC [ RunTime:0.031240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56995509 LIMIT 2 [ RunTime:0.011151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56995509 ORDER BY `minOrder` ASC [ RunTime:0.003287s ]
select * from pdf where partno='67413J' and brandshort='Advanced Micro Devices' limit 1 [ RunTime:0.011406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67413J' OR `brand` LIKE 'Advanced Micro Devices%' ) ) LIMIT 1 [ RunTime:0.015921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908127 LIMIT 5 [ RunTime:0.022266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908127 ORDER BY `minOrder` ASC [ RunTime:0.023837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908127 ORDER BY `unit` DESC [ RunTime:0.026317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908127 LIMIT 2 [ RunTime:0.014705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908127 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='6741' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.005494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6741' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.032827s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908127 AND `partno` = '6741' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.015431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879609 [ RunTime:0.018165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60606324 LIMIT 5 [ RunTime:0.003507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606324 ORDER BY `minOrder` ASC [ RunTime:0.024880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60606324 ORDER BY `unit` DESC [ RunTime:0.007546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60606324 LIMIT 2 [ RunTime:0.077765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606324 ORDER BY `minOrder` ASC [ RunTime:0.001881s ]
select * from pdf where partno='6744' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.017092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6744' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.021779s ]
SELECT `id` FROM `stock` WHERE `id` <> 60606324 AND `partno` = '6744' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.023097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15548191 [ RunTime:0.021548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56995404 LIMIT 5 [ RunTime:0.028009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56995404 ORDER BY `minOrder` ASC [ RunTime:0.030160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56995404 ORDER BY `unit` DESC [ RunTime:0.046515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56995404 LIMIT 2 [ RunTime:0.029657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56995404 ORDER BY `minOrder` ASC [ RunTime:0.015239s ]
select * from pdf where partno='67402J' and brandshort='Advanced Micro Devices' limit 1 [ RunTime:0.013066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67402J' OR `brand` LIKE 'Advanced Micro Devices%' ) ) LIMIT 1 [ RunTime:0.030493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62420018 LIMIT 5 [ RunTime:0.022329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62420018 ORDER BY `minOrder` ASC [ RunTime:0.020290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62420018 ORDER BY `unit` DESC [ RunTime:0.014064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62420018 LIMIT 2 [ RunTime:0.006915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62420018 ORDER BY `minOrder` ASC [ RunTime:0.008197s ]
select * from pdf where partno='67400-242-AB' and brandshort='Inventus Power' limit 1 [ RunTime:0.009184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67400-242-AB' OR `brand` LIKE 'Inventus Power%' ) ) LIMIT 1 [ RunTime:0.011522s ]
SELECT `id` FROM `stock` WHERE `id` <> 62420018 AND `partno` = '67400-242-AB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%inventus power%' ) [ RunTime:0.004188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14434271 [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62419794 LIMIT 5 [ RunTime:0.016228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62419794 ORDER BY `minOrder` ASC [ RunTime:0.019064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62419794 ORDER BY `unit` DESC [ RunTime:0.008138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62419794 LIMIT 2 [ RunTime:0.016622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62419794 ORDER BY `minOrder` ASC [ RunTime:0.004384s ]
select * from pdf where partno='67400-277-AB' and brandshort='Inventus Power' limit 1 [ RunTime:0.018385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67400-277-AB' OR `brand` LIKE 'Inventus Power%' ) ) LIMIT 1 [ RunTime:0.014772s ]
SELECT `id` FROM `stock` WHERE `id` <> 62419794 AND `partno` = '67400-277-AB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%inventus power%' ) [ RunTime:0.006259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14434277 [ RunTime:0.024804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60606679 LIMIT 5 [ RunTime:0.031472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606679 ORDER BY `minOrder` ASC [ RunTime:0.017129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60606679 ORDER BY `unit` DESC [ RunTime:0.001418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60606679 LIMIT 2 [ RunTime:0.008317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606679 ORDER BY `minOrder` ASC [ RunTime:0.002234s ]
select * from pdf where partno='6740' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.027145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6740' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.029461s ]
SELECT `id` FROM `stock` WHERE `id` <> 60606679 AND `partno` = '6740' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.012539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371949 [ RunTime:0.009826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56609629 LIMIT 5 [ RunTime:0.003704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56609629 ORDER BY `minOrder` ASC [ RunTime:0.004409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56609629 ORDER BY `unit` DESC [ RunTime:0.020784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56609629 LIMIT 2 [ RunTime:0.009869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56609629 ORDER BY `minOrder` ASC [ RunTime:0.007142s ]
select * from pdf where partno='6747TE' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.012141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6747TE' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.001124s ]
SELECT `id` FROM `stock` WHERE `id` <> 56609629 AND `partno` = '6747TE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.005899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19023901 [ RunTime:0.008354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56612578 LIMIT 5 [ RunTime:0.004090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56612578 ORDER BY `minOrder` ASC [ RunTime:0.023023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56612578 ORDER BY `unit` DESC [ RunTime:0.008562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56612578 LIMIT 2 [ RunTime:0.013181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56612578 ORDER BY `minOrder` ASC [ RunTime:0.009074s ]
select * from pdf where partno='6748TE' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.015781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6748TE' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.001523s ]
SELECT `id` FROM `stock` WHERE `id` <> 56612578 AND `partno` = '6748TE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.002126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14204693 [ RunTime:0.006823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57273852 LIMIT 5 [ RunTime:0.014427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57273852 ORDER BY `minOrder` ASC [ RunTime:0.023695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57273852 ORDER BY `unit` DESC [ RunTime:0.023081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57273852 LIMIT 2 [ RunTime:0.006602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57273852 ORDER BY `minOrder` ASC [ RunTime:0.001852s ]
select * from pdf where partno='6742-30' and brandshort='Phoenix America' limit 1 [ RunTime:0.006645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6742-30' OR `brand` LIKE 'Phoenix America%' ) ) LIMIT 1 [ RunTime:0.003605s ]
SELECT `id` FROM `stock` WHERE `id` <> 57273852 AND `partno` = '6742-30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%phoenix america%' ) [ RunTime:0.005975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913036 LIMIT 5 [ RunTime:0.003831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913036 ORDER BY `minOrder` ASC [ RunTime:0.008993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913036 ORDER BY `unit` DESC [ RunTime:0.014631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913036 LIMIT 2 [ RunTime:0.007541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913036 ORDER BY `minOrder` ASC [ RunTime:0.007921s ]
select * from pdf where partno='6748' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.008628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6748' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.014225s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913036 AND `partno` = '6748' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.008175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880619 [ RunTime:0.003736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56640181 LIMIT 5 [ RunTime:0.008421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56640181 ORDER BY `minOrder` ASC [ RunTime:0.014263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56640181 ORDER BY `unit` DESC [ RunTime:0.007011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56640181 LIMIT 2 [ RunTime:0.002889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56640181 ORDER BY `minOrder` ASC [ RunTime:0.001450s ]
select * from pdf where partno='6745RL' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.001262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6745RL' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.002583s ]
SELECT `id` FROM `stock` WHERE `id` <> 56640181 AND `partno` = '6745RL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.002459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15268724 [ RunTime:0.001036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56612063 LIMIT 5 [ RunTime:0.002571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56612063 ORDER BY `minOrder` ASC [ RunTime:0.002050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56612063 ORDER BY `unit` DESC [ RunTime:0.001625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56612063 LIMIT 2 [ RunTime:0.001121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56612063 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='6745AB' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.000949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6745AB' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.006123s ]
SELECT `id` FROM `stock` WHERE `id` <> 56612063 AND `partno` = '6745AB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.000867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274840 [ RunTime:0.000645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61916007 LIMIT 5 [ RunTime:0.002450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61916007 ORDER BY `minOrder` ASC [ RunTime:0.004155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61916007 ORDER BY `unit` DESC [ RunTime:0.001346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61916007 LIMIT 2 [ RunTime:0.001245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61916007 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='6747' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.002960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6747' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.007722s ]
SELECT `id` FROM `stock` WHERE `id` <> 61916007 AND `partno` = '6747' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.003690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880602 [ RunTime:0.001381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58510703 LIMIT 5 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58510703 ORDER BY `minOrder` ASC [ RunTime:0.009799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58510703 ORDER BY `unit` DESC [ RunTime:0.003191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58510703 LIMIT 2 [ RunTime:0.002548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58510703 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='67442-1-7612' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.002707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67442-1-7612' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.001347s ]
SELECT `id` FROM `stock` WHERE `id` <> 58510703 AND `partno` = '67442-1-7612' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.000972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588242 [ RunTime:0.001730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56460114 LIMIT 5 [ RunTime:0.009753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56460114 ORDER BY `minOrder` ASC [ RunTime:0.012111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56460114 ORDER BY `unit` DESC [ RunTime:0.010407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56460114 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56460114 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='674A91' and brandshort='Amphenol PCB Piezotronics' limit 1 [ RunTime:0.005730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '674A91' OR `brand` LIKE 'Amphenol PCB Piezotronics%' ) ) LIMIT 1 [ RunTime:0.001333s ]
SELECT `id` FROM `stock` WHERE `id` <> 56460114 AND `partno` = '674A91' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol pcb piezotronics%' ) [ RunTime:0.000738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14255078 [ RunTime:0.002066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56620343 LIMIT 5 [ RunTime:0.008477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56620343 ORDER BY `minOrder` ASC [ RunTime:0.014610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56620343 ORDER BY `unit` DESC [ RunTime:0.001641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56620343 LIMIT 2 [ RunTime:0.002890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56620343 ORDER BY `minOrder` ASC [ RunTime:0.005773s ]
select * from pdf where partno='6742UB' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.003222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6742UB' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.010467s ]
SELECT `id` FROM `stock` WHERE `id` <> 56620343 AND `partno` = '6742UB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.023304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035763 [ RunTime:0.005266s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005177s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002899s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004321s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013061s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012104s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001267s ]
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 '674%' OR `brand` LIKE '674%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009148s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '674%' OR `brand` LIKE '674%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002363s ]