SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002546s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010615s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963345 LIMIT 5 [ RunTime:0.000895s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963345 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963345 ORDER BY `unit` DESC [ RunTime:0.017275s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963345 LIMIT 2 [ RunTime:0.009258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963345 ORDER BY `minOrder` ASC [ RunTime:0.001895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963344 LIMIT 5 [ RunTime:0.002377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963344 ORDER BY `minOrder` ASC [ RunTime:0.006879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963344 ORDER BY `unit` DESC [ RunTime:0.013060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963344 LIMIT 2 [ RunTime:0.001506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963344 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963343 LIMIT 5 [ RunTime:0.001932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963343 ORDER BY `minOrder` ASC [ RunTime:0.020269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963343 ORDER BY `unit` DESC [ RunTime:0.032023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963343 LIMIT 2 [ RunTime:0.017454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963343 ORDER BY `minOrder` ASC [ RunTime:0.001956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963342 LIMIT 5 [ RunTime:0.019049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963342 ORDER BY `minOrder` ASC [ RunTime:0.010259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963342 ORDER BY `unit` DESC [ RunTime:0.004354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963342 LIMIT 2 [ RunTime:0.007366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963342 ORDER BY `minOrder` ASC [ RunTime:0.001467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963341 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963341 ORDER BY `minOrder` ASC [ RunTime:0.016122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963341 ORDER BY `unit` DESC [ RunTime:0.021416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963341 LIMIT 2 [ RunTime:0.007748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963341 ORDER BY `minOrder` ASC [ RunTime:0.003371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963340 LIMIT 5 [ RunTime:0.007451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963340 ORDER BY `minOrder` ASC [ RunTime:0.014960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963340 ORDER BY `unit` DESC [ RunTime:0.014576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963340 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963340 ORDER BY `minOrder` ASC [ RunTime:0.011991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963339 LIMIT 5 [ RunTime:0.004159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963339 ORDER BY `minOrder` ASC [ RunTime:0.011924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963339 ORDER BY `unit` DESC [ RunTime:0.011722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963339 LIMIT 2 [ RunTime:0.034326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963339 ORDER BY `minOrder` ASC [ RunTime:0.023587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963338 LIMIT 5 [ RunTime:0.011157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963338 ORDER BY `minOrder` ASC [ RunTime:0.016866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963338 ORDER BY `unit` DESC [ RunTime:0.001775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963338 LIMIT 2 [ RunTime:0.003851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963338 ORDER BY `minOrder` ASC [ RunTime:0.028067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961317 LIMIT 5 [ RunTime:0.030653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961317 ORDER BY `minOrder` ASC [ RunTime:0.013053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961317 ORDER BY `unit` DESC [ RunTime:0.024591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961317 LIMIT 2 [ RunTime:0.012886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961317 ORDER BY `minOrder` ASC [ RunTime:0.023390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961316 LIMIT 5 [ RunTime:0.017319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961316 ORDER BY `minOrder` ASC [ RunTime:0.016432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961316 ORDER BY `unit` DESC [ RunTime:0.017834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961316 LIMIT 2 [ RunTime:0.049059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961316 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961315 LIMIT 5 [ RunTime:0.004314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961315 ORDER BY `minOrder` ASC [ RunTime:0.012133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961315 ORDER BY `unit` DESC [ RunTime:0.037199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961315 LIMIT 2 [ RunTime:0.010941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961315 ORDER BY `minOrder` ASC [ RunTime:0.021141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961314 LIMIT 5 [ RunTime:0.024561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961314 ORDER BY `minOrder` ASC [ RunTime:0.024493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961314 ORDER BY `unit` DESC [ RunTime:0.027364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961314 LIMIT 2 [ RunTime:0.047388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961314 ORDER BY `minOrder` ASC [ RunTime:0.024069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961313 LIMIT 5 [ RunTime:0.013121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961313 ORDER BY `minOrder` ASC [ RunTime:0.007693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961313 ORDER BY `unit` DESC [ RunTime:0.012702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961313 LIMIT 2 [ RunTime:0.011070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961313 ORDER BY `minOrder` ASC [ RunTime:0.004048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961312 LIMIT 5 [ RunTime:0.006213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961312 ORDER BY `minOrder` ASC [ RunTime:0.007710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961312 ORDER BY `unit` DESC [ RunTime:0.009541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961312 LIMIT 2 [ RunTime:0.009423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961312 ORDER BY `minOrder` ASC [ RunTime:0.003574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12960845 LIMIT 5 [ RunTime:0.014539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960845 ORDER BY `minOrder` ASC [ RunTime:0.005099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12960845 ORDER BY `unit` DESC [ RunTime:0.000819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12960845 LIMIT 2 [ RunTime:0.014345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960845 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12960844 LIMIT 5 [ RunTime:0.012185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960844 ORDER BY `minOrder` ASC [ RunTime:0.017672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12960844 ORDER BY `unit` DESC [ RunTime:0.011531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12960844 LIMIT 2 [ RunTime:0.011047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960844 ORDER BY `minOrder` ASC [ RunTime:0.015862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12960843 LIMIT 5 [ RunTime:0.039310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960843 ORDER BY `minOrder` ASC [ RunTime:0.014626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12960843 ORDER BY `unit` DESC [ RunTime:0.005947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12960843 LIMIT 2 [ RunTime:0.036167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960843 ORDER BY `minOrder` ASC [ RunTime:0.017488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12960842 LIMIT 5 [ RunTime:0.019827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960842 ORDER BY `minOrder` ASC [ RunTime:0.046584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12960842 ORDER BY `unit` DESC [ RunTime:0.021797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12960842 LIMIT 2 [ RunTime:0.032183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960842 ORDER BY `minOrder` ASC [ RunTime:0.005732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12960841 LIMIT 5 [ RunTime:0.019855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960841 ORDER BY `minOrder` ASC [ RunTime:0.019709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12960841 ORDER BY `unit` DESC [ RunTime:0.038404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12960841 LIMIT 2 [ RunTime:0.027780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960841 ORDER BY `minOrder` ASC [ RunTime:0.016594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12960840 LIMIT 5 [ RunTime:0.012417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960840 ORDER BY `minOrder` ASC [ RunTime:0.024290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12960840 ORDER BY `unit` DESC [ RunTime:0.023287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12960840 LIMIT 2 [ RunTime:0.020430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960840 ORDER BY `minOrder` ASC [ RunTime:0.021903s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054173s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61172946 LIMIT 5 [ RunTime:0.019948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61172946 ORDER BY `minOrder` ASC [ RunTime:0.018881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61172946 ORDER BY `unit` DESC [ RunTime:0.001206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61172946 LIMIT 2 [ RunTime:0.028774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61172946 ORDER BY `minOrder` ASC [ RunTime:0.053166s ]
select * from pdf where partno='JT00A-12-98P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.025607s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003484s ]
SELECT `id` FROM `stock` WHERE `id` <> 61172946 AND `partno` = 'JT00A-12-98P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60277917 LIMIT 5 [ RunTime:0.036270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60277917 ORDER BY `minOrder` ASC [ RunTime:0.067296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60277917 ORDER BY `unit` DESC [ RunTime:0.045558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60277917 LIMIT 2 [ RunTime:0.006449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60277917 ORDER BY `minOrder` ASC [ RunTime:0.011513s ]
select * from pdf where partno='JT00A-12-98PA(363)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.031077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PA(363)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.023900s ]
SELECT `id` FROM `stock` WHERE `id` <> 60277917 AND `partno` = 'JT00A-12-98PA(363)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.040085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60277916 LIMIT 5 [ RunTime:0.037338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60277916 ORDER BY `minOrder` ASC [ RunTime:0.018597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60277916 ORDER BY `unit` DESC [ RunTime:0.042941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60277916 LIMIT 2 [ RunTime:0.019416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60277916 ORDER BY `minOrder` ASC [ RunTime:0.011052s ]
select * from pdf where partno='JT00A-12-98PD(363)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.028551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PD(363)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.005198s ]
SELECT `id` FROM `stock` WHERE `id` <> 60277916 AND `partno` = 'JT00A-12-98PD(363)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.023074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60277915 LIMIT 5 [ RunTime:0.013890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60277915 ORDER BY `minOrder` ASC [ RunTime:0.028246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60277915 ORDER BY `unit` DESC [ RunTime:0.027353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60277915 LIMIT 2 [ RunTime:0.014631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60277915 ORDER BY `minOrder` ASC [ RunTime:0.002661s ]
select * from pdf where partno='JT00A-12-98PC(363)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PC(363)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006761s ]
SELECT `id` FROM `stock` WHERE `id` <> 60277915 AND `partno` = 'JT00A-12-98PC(363)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60277914 LIMIT 5 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60277914 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60277914 ORDER BY `unit` DESC [ RunTime:0.006882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60277914 LIMIT 2 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60277914 ORDER BY `minOrder` ASC [ RunTime:0.001054s ]
select * from pdf where partno='JT00A-12-98PB(363)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.009554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PB(363)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003753s ]
SELECT `id` FROM `stock` WHERE `id` <> 60277914 AND `partno` = 'JT00A-12-98PB(363)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276706 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276706 ORDER BY `minOrder` ASC [ RunTime:0.001187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276706 ORDER BY `unit` DESC [ RunTime:0.005881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276706 LIMIT 2 [ RunTime:0.002569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276706 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='JT00A-12-98PA(345)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PA(345)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000875s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276706 AND `partno` = 'JT00A-12-98PA(345)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11740836 [ RunTime:0.002149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276705 LIMIT 5 [ RunTime:0.008466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276705 ORDER BY `minOrder` ASC [ RunTime:0.002455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276705 ORDER BY `unit` DESC [ RunTime:0.002147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276705 LIMIT 2 [ RunTime:0.003726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276705 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
select * from pdf where partno='JT00A-12-98PA(434)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PA(434)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001508s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276705 AND `partno` = 'JT00A-12-98PA(434)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963345 [ RunTime:0.000648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276704 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276704 ORDER BY `minOrder` ASC [ RunTime:0.004751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276704 ORDER BY `unit` DESC [ RunTime:0.001864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276704 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276704 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='JT00A-12-98PA(302)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PA(302)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001906s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276704 AND `partno` = 'JT00A-12-98PA(302)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963344 [ RunTime:0.005270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276703 LIMIT 5 [ RunTime:0.002409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276703 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276703 ORDER BY `unit` DESC [ RunTime:0.000640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276703 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276703 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='JT00A-12-98PD(345)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PD(345)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002476s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276703 AND `partno` = 'JT00A-12-98PD(345)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.009520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11740835 [ RunTime:0.001970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276702 LIMIT 5 [ RunTime:0.004329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276702 ORDER BY `minOrder` ASC [ RunTime:0.001905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276702 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276702 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276702 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
select * from pdf where partno='JT00A-12-98PD(302)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PD(302)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000817s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276702 AND `partno` = 'JT00A-12-98PD(302)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963343 [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276701 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276701 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276701 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276701 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276701 ORDER BY `minOrder` ASC [ RunTime:0.000762s ]
select * from pdf where partno='JT00A-12-98PD(434)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.042902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PD(434)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012535s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276701 AND `partno` = 'JT00A-12-98PD(434)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.027151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963342 [ RunTime:0.008120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276700 LIMIT 5 [ RunTime:0.011166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276700 ORDER BY `minOrder` ASC [ RunTime:0.013816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276700 ORDER BY `unit` DESC [ RunTime:0.014740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276700 LIMIT 2 [ RunTime:0.007157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276700 ORDER BY `minOrder` ASC [ RunTime:0.004371s ]
select * from pdf where partno='JT00A-12-98PC(434)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PC(434)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000879s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276700 AND `partno` = 'JT00A-12-98PC(434)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.005804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963341 [ RunTime:0.010605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276699 LIMIT 5 [ RunTime:0.001088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276699 ORDER BY `minOrder` ASC [ RunTime:0.001342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276699 ORDER BY `unit` DESC [ RunTime:0.003394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276699 LIMIT 2 [ RunTime:0.001229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276699 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
select * from pdf where partno='JT00A-12-98PC(302)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PC(302)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000866s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276699 AND `partno` = 'JT00A-12-98PC(302)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963340 [ RunTime:0.000705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276698 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276698 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276698 ORDER BY `unit` DESC [ RunTime:0.001931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276698 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276698 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='JT00A-12-98PC(345)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PC(345)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001763s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276698 AND `partno` = 'JT00A-12-98PC(345)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276697 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276697 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276697 ORDER BY `unit` DESC [ RunTime:0.001273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276697 LIMIT 2 [ RunTime:0.004647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276697 ORDER BY `minOrder` ASC [ RunTime:0.010132s ]
select * from pdf where partno='JT00A-12-98PB(434)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PB(434)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003690s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276697 AND `partno` = 'JT00A-12-98PB(434)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276696 LIMIT 5 [ RunTime:0.004136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276696 ORDER BY `minOrder` ASC [ RunTime:0.002628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276696 ORDER BY `unit` DESC [ RunTime:0.002302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276696 LIMIT 2 [ RunTime:0.003305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276696 ORDER BY `minOrder` ASC [ RunTime:0.003043s ]
select * from pdf where partno='JT00A-12-98PB(345)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PB(345)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001450s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276696 AND `partno` = 'JT00A-12-98PB(345)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963339 [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60276695 LIMIT 5 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276695 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60276695 ORDER BY `unit` DESC [ RunTime:0.004218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60276695 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60276695 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='JT00A-12-98PB(302)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PB(302)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001768s ]
SELECT `id` FROM `stock` WHERE `id` <> 60276695 AND `partno` = 'JT00A-12-98PB(302)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963338 [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60271395 LIMIT 5 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60271395 ORDER BY `minOrder` ASC [ RunTime:0.001503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60271395 ORDER BY `unit` DESC [ RunTime:0.009650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60271395 LIMIT 2 [ RunTime:0.002121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60271395 ORDER BY `minOrder` ASC [ RunTime:0.000680s ]
select * from pdf where partno='JT00A-12-98PA(409)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PA(409)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001676s ]
SELECT `id` FROM `stock` WHERE `id` <> 60271395 AND `partno` = 'JT00A-12-98PA(409)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739243 [ RunTime:0.001319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60271394 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60271394 ORDER BY `minOrder` ASC [ RunTime:0.000951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60271394 ORDER BY `unit` DESC [ RunTime:0.008904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60271394 LIMIT 2 [ RunTime:0.004701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60271394 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
select * from pdf where partno='JT00A-12-98PA(318)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PA(318)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000830s ]
SELECT `id` FROM `stock` WHERE `id` <> 60271394 AND `partno` = 'JT00A-12-98PA(318)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961317 [ RunTime:0.005039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60271393 LIMIT 5 [ RunTime:0.003083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60271393 ORDER BY `minOrder` ASC [ RunTime:0.014966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60271393 ORDER BY `unit` DESC [ RunTime:0.003403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60271393 LIMIT 2 [ RunTime:0.008913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60271393 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='JT00A-12-98PA(328)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-98PA(328)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.004799s ]
SELECT `id` FROM `stock` WHERE `id` <> 60271393 AND `partno` = 'JT00A-12-98PA(328)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961316 [ RunTime:0.003467s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001824s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001115s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005989s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004342s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002072s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006646s ]
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 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007053s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'JT00A-12-98P%' OR `brand` LIKE 'JT00A-12-98P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002234s ]