SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002402s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029153s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.021758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18053300 LIMIT 5 [ RunTime:0.011810s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18053300 ORDER BY `minOrder` ASC [ RunTime:0.017198s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18053300 ORDER BY `unit` DESC [ RunTime:0.033884s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18053300 LIMIT 2 [ RunTime:0.012392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18053300 ORDER BY `minOrder` ASC [ RunTime:0.010182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14119560 LIMIT 5 [ RunTime:0.007766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14119560 ORDER BY `minOrder` ASC [ RunTime:0.004130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14119560 ORDER BY `unit` DESC [ RunTime:0.026803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14119560 LIMIT 2 [ RunTime:0.012918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14119560 ORDER BY `minOrder` ASC [ RunTime:0.002733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18178786 LIMIT 5 [ RunTime:0.024076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18178786 ORDER BY `minOrder` ASC [ RunTime:0.005396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18178786 ORDER BY `unit` DESC [ RunTime:0.025576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18178786 LIMIT 2 [ RunTime:0.004455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18178786 ORDER BY `minOrder` ASC [ RunTime:0.012689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18053307 LIMIT 5 [ RunTime:0.052311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18053307 ORDER BY `minOrder` ASC [ RunTime:0.020806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18053307 ORDER BY `unit` DESC [ RunTime:0.019550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18053307 LIMIT 2 [ RunTime:0.011999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18053307 ORDER BY `minOrder` ASC [ RunTime:0.008619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18048874 LIMIT 5 [ RunTime:0.059484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18048874 ORDER BY `minOrder` ASC [ RunTime:0.036801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18048874 ORDER BY `unit` DESC [ RunTime:0.017889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18048874 LIMIT 2 [ RunTime:0.021380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18048874 ORDER BY `minOrder` ASC [ RunTime:0.022550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18053309 LIMIT 5 [ RunTime:0.015993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18053309 ORDER BY `minOrder` ASC [ RunTime:0.026811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18053309 ORDER BY `unit` DESC [ RunTime:0.047829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18053309 LIMIT 2 [ RunTime:0.020913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18053309 ORDER BY `minOrder` ASC [ RunTime:0.022017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18050891 LIMIT 5 [ RunTime:0.038704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18050891 ORDER BY `minOrder` ASC [ RunTime:0.028236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18050891 ORDER BY `unit` DESC [ RunTime:0.030687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18050891 LIMIT 2 [ RunTime:0.028131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18050891 ORDER BY `minOrder` ASC [ RunTime:0.013060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15038540 LIMIT 5 [ RunTime:0.035297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15038540 ORDER BY `minOrder` ASC [ RunTime:0.028755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15038540 ORDER BY `unit` DESC [ RunTime:0.033316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15038540 LIMIT 2 [ RunTime:0.012550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15038540 ORDER BY `minOrder` ASC [ RunTime:0.021778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15088608 LIMIT 5 [ RunTime:0.053178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15088608 ORDER BY `minOrder` ASC [ RunTime:0.051961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15088608 ORDER BY `unit` DESC [ RunTime:0.055522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15088608 LIMIT 2 [ RunTime:0.026010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15088608 ORDER BY `minOrder` ASC [ RunTime:0.004849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18181908 LIMIT 5 [ RunTime:0.021840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18181908 ORDER BY `minOrder` ASC [ RunTime:0.016634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18181908 ORDER BY `unit` DESC [ RunTime:0.021855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18181908 LIMIT 2 [ RunTime:0.032907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18181908 ORDER BY `minOrder` ASC [ RunTime:0.011157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18059067 LIMIT 5 [ RunTime:0.013823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18059067 ORDER BY `minOrder` ASC [ RunTime:0.023757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18059067 ORDER BY `unit` DESC [ RunTime:0.005105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18059067 LIMIT 2 [ RunTime:0.007989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18059067 ORDER BY `minOrder` ASC [ RunTime:0.009569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18188004 LIMIT 5 [ RunTime:0.015019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18188004 ORDER BY `minOrder` ASC [ RunTime:0.021226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18188004 ORDER BY `unit` DESC [ RunTime:0.016663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18188004 LIMIT 2 [ RunTime:0.072096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18188004 ORDER BY `minOrder` ASC [ RunTime:0.011969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14097954 LIMIT 5 [ RunTime:0.019438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14097954 ORDER BY `minOrder` ASC [ RunTime:0.000640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14097954 ORDER BY `unit` DESC [ RunTime:0.017701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14097954 LIMIT 2 [ RunTime:0.018934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14097954 ORDER BY `minOrder` ASC [ RunTime:0.011002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15724065 LIMIT 5 [ RunTime:0.024794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15724065 ORDER BY `minOrder` ASC [ RunTime:0.015216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15724065 ORDER BY `unit` DESC [ RunTime:0.014869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15724065 LIMIT 2 [ RunTime:0.029477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15724065 ORDER BY `minOrder` ASC [ RunTime:0.026027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18274240 LIMIT 5 [ RunTime:0.014584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18274240 ORDER BY `minOrder` ASC [ RunTime:0.010175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18274240 ORDER BY `unit` DESC [ RunTime:0.047489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18274240 LIMIT 2 [ RunTime:0.033502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18274240 ORDER BY `minOrder` ASC [ RunTime:0.032254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18054029 LIMIT 5 [ RunTime:0.010604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18054029 ORDER BY `minOrder` ASC [ RunTime:0.003690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18054029 ORDER BY `unit` DESC [ RunTime:0.012246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18054029 LIMIT 2 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18054029 ORDER BY `minOrder` ASC [ RunTime:0.000813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18054780 LIMIT 5 [ RunTime:0.015989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18054780 ORDER BY `minOrder` ASC [ RunTime:0.021060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18054780 ORDER BY `unit` DESC [ RunTime:0.034776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18054780 LIMIT 2 [ RunTime:0.025849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18054780 ORDER BY `minOrder` ASC [ RunTime:0.015588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18371743 LIMIT 5 [ RunTime:0.026851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18371743 ORDER BY `minOrder` ASC [ RunTime:0.014869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18371743 ORDER BY `unit` DESC [ RunTime:0.044378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18371743 LIMIT 2 [ RunTime:0.012881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18371743 ORDER BY `minOrder` ASC [ RunTime:0.014410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16811708 LIMIT 5 [ RunTime:0.025845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16811708 ORDER BY `minOrder` ASC [ RunTime:0.007890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16811708 ORDER BY `unit` DESC [ RunTime:0.010737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16811708 LIMIT 2 [ RunTime:0.007845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16811708 ORDER BY `minOrder` ASC [ RunTime:0.015526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15789059 LIMIT 5 [ RunTime:0.024816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15789059 ORDER BY `minOrder` ASC [ RunTime:0.020293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15789059 ORDER BY `unit` DESC [ RunTime:0.016638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15789059 LIMIT 2 [ RunTime:0.055840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15789059 ORDER BY `minOrder` ASC [ RunTime:0.027897s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078689 LIMIT 5 [ RunTime:0.023631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078689 ORDER BY `minOrder` ASC [ RunTime:0.119660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078689 ORDER BY `unit` DESC [ RunTime:0.036386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078689 LIMIT 2 [ RunTime:0.075160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078689 ORDER BY `minOrder` ASC [ RunTime:0.022248s ]
select * from pdf where partno='crs2f3111-100' and brandshort='lantronix' limit 1 [ RunTime:0.014752s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'crs2f3111-100' OR `brand` LIKE 'lantronix%' ) ) LIMIT 1 [ RunTime:0.028647s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078689 AND `partno` = 'crs2f3111-100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lantronix%' ) [ RunTime:0.039845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13279899 [ RunTime:0.022691s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33002410 LIMIT 5 [ RunTime:0.006500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33002410 ORDER BY `minOrder` ASC [ RunTime:0.021421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33002410 ORDER BY `unit` DESC [ RunTime:0.003739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33002410 LIMIT 2 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33002410 ORDER BY `minOrder` ASC [ RunTime:0.006351s ]
select * from pdf where partno='CRS2512AJW-102ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.014603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512AJW-102ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.017921s ]
SELECT `id` FROM `stock` WHERE `id` <> 33002410 AND `partno` = 'CRS2512AJW-102ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.009937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14119560 [ RunTime:0.001852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33001535 LIMIT 5 [ RunTime:0.003670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33001535 ORDER BY `minOrder` ASC [ RunTime:0.020113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33001535 ORDER BY `unit` DESC [ RunTime:0.013193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33001535 LIMIT 2 [ RunTime:0.002572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33001535 ORDER BY `minOrder` ASC [ RunTime:0.013969s ]
select * from pdf where partno='CRS2512-FX-10R0ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512-FX-10R0ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.016500s ]
SELECT `id` FROM `stock` WHERE `id` <> 33001535 AND `partno` = 'CRS2512-FX-10R0ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.031632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18053307 [ RunTime:0.026993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33137180 LIMIT 5 [ RunTime:0.014554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33137180 ORDER BY `minOrder` ASC [ RunTime:0.014251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33137180 ORDER BY `unit` DESC [ RunTime:0.007368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33137180 LIMIT 2 [ RunTime:0.008800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33137180 ORDER BY `minOrder` ASC [ RunTime:0.003247s ]
select * from pdf where partno='CRS2010-JW-4R7ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2010-JW-4R7ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.027128s ]
SELECT `id` FROM `stock` WHERE `id` <> 33137180 AND `partno` = 'CRS2010-JW-4R7ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.020137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18178786 [ RunTime:0.015596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33000548 LIMIT 5 [ RunTime:0.053709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000548 ORDER BY `minOrder` ASC [ RunTime:0.020768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33000548 ORDER BY `unit` DESC [ RunTime:0.033280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33000548 LIMIT 2 [ RunTime:0.024671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000548 ORDER BY `minOrder` ASC [ RunTime:0.016366s ]
select * from pdf where partno='CRS2512-JX-100ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.024834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512-JX-100ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.034659s ]
SELECT `id` FROM `stock` WHERE `id` <> 33000548 AND `partno` = 'CRS2512-JX-100ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.011992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15038540 [ RunTime:0.010237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32999462 LIMIT 5 [ RunTime:0.006288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32999462 ORDER BY `minOrder` ASC [ RunTime:0.037955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32999462 ORDER BY `unit` DESC [ RunTime:0.007704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32999462 LIMIT 2 [ RunTime:0.015375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32999462 ORDER BY `minOrder` ASC [ RunTime:0.006001s ]
select * from pdf where partno='CRS2010-FX-1004ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.011897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2010-FX-1004ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.025566s ]
SELECT `id` FROM `stock` WHERE `id` <> 32999462 AND `partno` = 'CRS2010-FX-1004ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.018460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18048874 [ RunTime:0.009572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33000561 LIMIT 5 [ RunTime:0.003197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000561 ORDER BY `minOrder` ASC [ RunTime:0.008478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33000561 ORDER BY `unit` DESC [ RunTime:0.003755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33000561 LIMIT 2 [ RunTime:0.014734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000561 ORDER BY `minOrder` ASC [ RunTime:0.013700s ]
select * from pdf where partno='CRS2512-JW-4R7ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.021128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512-JW-4R7ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003745s ]
SELECT `id` FROM `stock` WHERE `id` <> 33000561 AND `partno` = 'CRS2512-JW-4R7ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.023409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18050891 [ RunTime:0.070843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33140264 LIMIT 5 [ RunTime:0.010408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140264 ORDER BY `minOrder` ASC [ RunTime:0.033805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33140264 ORDER BY `unit` DESC [ RunTime:0.017044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33140264 LIMIT 2 [ RunTime:0.036534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140264 ORDER BY `minOrder` ASC [ RunTime:0.023997s ]
select * from pdf where partno='CRS2010-FW-4R99ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.017271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2010-FW-4R99ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.021832s ]
SELECT `id` FROM `stock` WHERE `id` <> 33140264 AND `partno` = 'CRS2010-FW-4R99ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.027036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15724065 [ RunTime:0.037129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33140268 LIMIT 5 [ RunTime:0.023018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140268 ORDER BY `minOrder` ASC [ RunTime:0.023283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33140268 ORDER BY `unit` DESC [ RunTime:0.025201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33140268 LIMIT 2 [ RunTime:0.021897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140268 ORDER BY `minOrder` ASC [ RunTime:0.017575s ]
select * from pdf where partno='CRS2010-FX-47R0ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2010-FX-47R0ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.006361s ]
SELECT `id` FROM `stock` WHERE `id` <> 33140268 AND `partno` = 'CRS2010-FX-47R0ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15088608 [ RunTime:0.008513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33140274 LIMIT 5 [ RunTime:0.000777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140274 ORDER BY `minOrder` ASC [ RunTime:0.003294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33140274 ORDER BY `unit` DESC [ RunTime:0.007216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33140274 LIMIT 2 [ RunTime:0.001620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140274 ORDER BY `minOrder` ASC [ RunTime:0.005109s ]
select * from pdf where partno='CRS2010-FX-1001ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2010-FX-1001ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000942s ]
SELECT `id` FROM `stock` WHERE `id` <> 33140274 AND `partno` = 'CRS2010-FX-1001ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18181940 [ RunTime:0.006489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084464 LIMIT 5 [ RunTime:0.005157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084464 ORDER BY `minOrder` ASC [ RunTime:0.001267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084464 ORDER BY `unit` DESC [ RunTime:0.007953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084464 LIMIT 2 [ RunTime:0.005095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084464 ORDER BY `minOrder` ASC [ RunTime:0.003125s ]
select * from pdf where partno='CRS20I30A(TE85L,QM' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.008256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS20I30A(TE85L,QM' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.013585s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084464 AND `partno` = 'CRS20I30A(TE85L,QM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.006075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33001546 LIMIT 5 [ RunTime:0.006216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33001546 ORDER BY `minOrder` ASC [ RunTime:0.000837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33001546 ORDER BY `unit` DESC [ RunTime:0.003747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33001546 LIMIT 2 [ RunTime:0.002423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33001546 ORDER BY `minOrder` ASC [ RunTime:0.003490s ]
select * from pdf where partno='CRS2512-FX-1001ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512-FX-1001ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003774s ]
SELECT `id` FROM `stock` WHERE `id` <> 33001546 AND `partno` = 'CRS2512-FX-1001ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14097954 [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084442 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084442 ORDER BY `minOrder` ASC [ RunTime:0.002333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084442 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084442 LIMIT 2 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084442 ORDER BY `minOrder` ASC [ RunTime:0.001495s ]
select * from pdf where partno='CRS20I40B(TE85L,QM' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.007567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS20I40B(TE85L,QM' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.000809s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084442 AND `partno` = 'CRS20I40B(TE85L,QM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.006967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32909119 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32909119 ORDER BY `minOrder` ASC [ RunTime:0.014382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32909119 ORDER BY `unit` DESC [ RunTime:0.009661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32909119 LIMIT 2 [ RunTime:0.004602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32909119 ORDER BY `minOrder` ASC [ RunTime:0.002395s ]
select * from pdf where partno='CRS2512-FW-3R30ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512-FW-3R30ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002469s ]
SELECT `id` FROM `stock` WHERE `id` <> 32909119 AND `partno` = 'CRS2512-FW-3R30ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18053300 [ RunTime:0.006555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33140296 LIMIT 5 [ RunTime:0.003385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140296 ORDER BY `minOrder` ASC [ RunTime:0.011729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33140296 ORDER BY `unit` DESC [ RunTime:0.005550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33140296 LIMIT 2 [ RunTime:0.003635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140296 ORDER BY `minOrder` ASC [ RunTime:0.007311s ]
select * from pdf where partno='CRS2010-FX-10R0ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2010-FX-10R0ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.006394s ]
SELECT `id` FROM `stock` WHERE `id` <> 33140296 AND `partno` = 'CRS2010-FX-10R0ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.008645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18181908 [ RunTime:0.004109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33278399 LIMIT 5 [ RunTime:0.004578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33278399 ORDER BY `minOrder` ASC [ RunTime:0.011738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33278399 ORDER BY `unit` DESC [ RunTime:0.001564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33278399 LIMIT 2 [ RunTime:0.001701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33278399 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
select * from pdf where partno='CRS2010-JX-332ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2010-JX-332ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.004981s ]
SELECT `id` FROM `stock` WHERE `id` <> 33278399 AND `partno` = 'CRS2010-JX-332ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18371743 [ RunTime:0.000821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33348516 LIMIT 5 [ RunTime:0.003601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33348516 ORDER BY `minOrder` ASC [ RunTime:0.001052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33348516 ORDER BY `unit` DESC [ RunTime:0.002803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33348516 LIMIT 2 [ RunTime:0.001897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33348516 ORDER BY `minOrder` ASC [ RunTime:0.002853s ]
select * from pdf where partno='CRS2512QJW-102ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512QJW-102ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.005534s ]
SELECT `id` FROM `stock` WHERE `id` <> 33348516 AND `partno` = 'CRS2512QJW-102ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.002409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16811708 [ RunTime:0.000629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33002740 LIMIT 5 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33002740 ORDER BY `minOrder` ASC [ RunTime:0.000825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33002740 ORDER BY `unit` DESC [ RunTime:0.002905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33002740 LIMIT 2 [ RunTime:0.001805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33002740 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
select * from pdf where partno='CRS2512AFX-47R0ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512AFX-47R0ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001324s ]
SELECT `id` FROM `stock` WHERE `id` <> 33002740 AND `partno` = 'CRS2512AFX-47R0ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.002928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18057501 [ RunTime:0.003915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44087173 LIMIT 5 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44087173 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44087173 ORDER BY `unit` DESC [ RunTime:0.002906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44087173 LIMIT 2 [ RunTime:0.003238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44087173 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='CRS20I40A(TE85L,QM' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.000820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS20I40A(TE85L,QM' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.002030s ]
SELECT `id` FROM `stock` WHERE `id` <> 44087173 AND `partno` = 'CRS20I40A(TE85L,QM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.008567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33001559 LIMIT 5 [ RunTime:0.002737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33001559 ORDER BY `minOrder` ASC [ RunTime:0.003186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33001559 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33001559 LIMIT 2 [ RunTime:0.001272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33001559 ORDER BY `minOrder` ASC [ RunTime:0.000774s ]
select * from pdf where partno='CRS2512-FX-1000ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2512-FX-1000ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002901s ]
SELECT `id` FROM `stock` WHERE `id` <> 33001559 AND `partno` = 'CRS2512-FX-1000ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18054029 [ RunTime:0.005474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33140356 LIMIT 5 [ RunTime:0.001695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140356 ORDER BY `minOrder` ASC [ RunTime:0.001993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33140356 ORDER BY `unit` DESC [ RunTime:0.000816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33140356 LIMIT 2 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33140356 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='CRS2010-FX-4701ELF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRS2010-FX-4701ELF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002735s ]
SELECT `id` FROM `stock` WHERE `id` <> 33140356 AND `partno` = 'CRS2010-FX-4701ELF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.002668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18274240 [ RunTime:0.003556s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001044s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000713s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000753s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000596s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001807s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001221s ]
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 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001589s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CRS2%' OR `brand` LIKE 'CRS2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011499s ]