SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001460s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019451s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11949503 LIMIT 5 [ RunTime:0.015522s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11949503 ORDER BY `minOrder` ASC [ RunTime:0.034268s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11949503 ORDER BY `unit` DESC [ RunTime:0.015269s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11949503 LIMIT 2 [ RunTime:0.034404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11949503 ORDER BY `minOrder` ASC [ RunTime:0.014673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16630934 LIMIT 5 [ RunTime:0.027742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16630934 ORDER BY `minOrder` ASC [ RunTime:0.034453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16630934 ORDER BY `unit` DESC [ RunTime:0.005455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16630934 LIMIT 2 [ RunTime:0.013748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16630934 ORDER BY `minOrder` ASC [ RunTime:0.003154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14719082 LIMIT 5 [ RunTime:0.030835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14719082 ORDER BY `minOrder` ASC [ RunTime:0.016209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14719082 ORDER BY `unit` DESC [ RunTime:0.013174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14719082 LIMIT 2 [ RunTime:0.004927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14719082 ORDER BY `minOrder` ASC [ RunTime:0.013567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14719023 LIMIT 5 [ RunTime:0.009246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14719023 ORDER BY `minOrder` ASC [ RunTime:0.025621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14719023 ORDER BY `unit` DESC [ RunTime:0.043145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14719023 LIMIT 2 [ RunTime:0.028366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14719023 ORDER BY `minOrder` ASC [ RunTime:0.011729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718642 LIMIT 5 [ RunTime:0.014643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14718642 ORDER BY `minOrder` ASC [ RunTime:0.021304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14718642 ORDER BY `unit` DESC [ RunTime:0.023398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14718642 LIMIT 2 [ RunTime:0.004694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14718642 ORDER BY `minOrder` ASC [ RunTime:0.001849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716862 LIMIT 5 [ RunTime:0.020693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716862 ORDER BY `minOrder` ASC [ RunTime:0.037965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14716862 ORDER BY `unit` DESC [ RunTime:0.012940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14716862 LIMIT 2 [ RunTime:0.004942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716862 ORDER BY `minOrder` ASC [ RunTime:0.010260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14715994 LIMIT 5 [ RunTime:0.015837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14715994 ORDER BY `minOrder` ASC [ RunTime:0.014567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14715994 ORDER BY `unit` DESC [ RunTime:0.013126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14715994 LIMIT 2 [ RunTime:0.005184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14715994 ORDER BY `minOrder` ASC [ RunTime:0.010974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14703032 LIMIT 5 [ RunTime:0.012430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14703032 ORDER BY `minOrder` ASC [ RunTime:0.013189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14703032 ORDER BY `unit` DESC [ RunTime:0.022012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14703032 LIMIT 2 [ RunTime:0.017373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14703032 ORDER BY `minOrder` ASC [ RunTime:0.007290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828806 LIMIT 5 [ RunTime:0.004153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828806 ORDER BY `minOrder` ASC [ RunTime:0.006194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13828806 ORDER BY `unit` DESC [ RunTime:0.012296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13828806 LIMIT 2 [ RunTime:0.015680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13828806 ORDER BY `minOrder` ASC [ RunTime:0.001481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827619 LIMIT 5 [ RunTime:0.009222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827619 ORDER BY `minOrder` ASC [ RunTime:0.012463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13827619 ORDER BY `unit` DESC [ RunTime:0.002480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13827619 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827619 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827247 LIMIT 5 [ RunTime:0.001131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827247 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13827247 ORDER BY `unit` DESC [ RunTime:0.011871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13827247 LIMIT 2 [ RunTime:0.005825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827247 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825646 LIMIT 5 [ RunTime:0.001921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825646 ORDER BY `minOrder` ASC [ RunTime:0.005419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13825646 ORDER BY `unit` DESC [ RunTime:0.006727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13825646 LIMIT 2 [ RunTime:0.005252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825646 ORDER BY `minOrder` ASC [ RunTime:0.005039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825580 LIMIT 5 [ RunTime:0.003467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825580 ORDER BY `minOrder` ASC [ RunTime:0.009192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13825580 ORDER BY `unit` DESC [ RunTime:0.003346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13825580 LIMIT 2 [ RunTime:0.018155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825580 ORDER BY `minOrder` ASC [ RunTime:0.010061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825286 LIMIT 5 [ RunTime:0.006846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825286 ORDER BY `minOrder` ASC [ RunTime:0.009983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13825286 ORDER BY `unit` DESC [ RunTime:0.048411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13825286 LIMIT 2 [ RunTime:0.004880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825286 ORDER BY `minOrder` ASC [ RunTime:0.019508s ]
select * from pdf where partno='L097231' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.012383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823963 LIMIT 5 [ RunTime:0.021991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823963 ORDER BY `minOrder` ASC [ RunTime:0.010030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13823963 ORDER BY `unit` DESC [ RunTime:0.023000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13823963 LIMIT 2 [ RunTime:0.032204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823963 ORDER BY `minOrder` ASC [ RunTime:0.019505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13216105 LIMIT 5 [ RunTime:0.017893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13216105 ORDER BY `minOrder` ASC [ RunTime:0.006394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13216105 ORDER BY `unit` DESC [ RunTime:0.036380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13216105 LIMIT 2 [ RunTime:0.004691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13216105 ORDER BY `minOrder` ASC [ RunTime:0.026169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13216100 LIMIT 5 [ RunTime:0.022957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13216100 ORDER BY `minOrder` ASC [ RunTime:0.008002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13216100 ORDER BY `unit` DESC [ RunTime:0.005290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13216100 LIMIT 2 [ RunTime:0.029789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13216100 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11949796 LIMIT 5 [ RunTime:0.016764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11949796 ORDER BY `minOrder` ASC [ RunTime:0.012814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11949796 ORDER BY `unit` DESC [ RunTime:0.005464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11949796 LIMIT 2 [ RunTime:0.008829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11949796 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002868s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64158447 LIMIT 5 [ RunTime:0.006527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158447 ORDER BY `minOrder` ASC [ RunTime:0.012201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64158447 ORDER BY `unit` DESC [ RunTime:0.014938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64158447 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158447 ORDER BY `minOrder` ASC [ RunTime:0.001324s ]
select * from pdf where partno='L095XG9S' and brandshort='Knowles Dielectric Labs' limit 1 [ RunTime:0.004507s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L095XG9S' OR `brand` LIKE 'Knowles Dielectric Labs%' ) ) LIMIT 1 [ RunTime:0.000959s ]
SELECT `id` FROM `stock` WHERE `id` <> 64158447 AND `partno` = 'L095XG9S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles dielectric labs%' ) [ RunTime:0.004818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11949503 [ RunTime:0.000587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64158434 LIMIT 5 [ RunTime:0.001791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158434 ORDER BY `minOrder` ASC [ RunTime:0.019236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64158434 ORDER BY `unit` DESC [ RunTime:0.002051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64158434 LIMIT 2 [ RunTime:0.000867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158434 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='L095XG9S-T' and brandshort='Knowles Dielectric Labs' limit 1 [ RunTime:0.001197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L095XG9S-T' OR `brand` LIKE 'Knowles Dielectric Labs%' ) ) LIMIT 1 [ RunTime:0.002937s ]
SELECT `id` FROM `stock` WHERE `id` <> 64158434 AND `partno` = 'L095XG9S-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles dielectric labs%' ) [ RunTime:0.009921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64161881 LIMIT 5 [ RunTime:0.002751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64161881 ORDER BY `minOrder` ASC [ RunTime:0.009067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64161881 ORDER BY `unit` DESC [ RunTime:0.006524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64161881 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64161881 ORDER BY `minOrder` ASC [ RunTime:0.002968s ]
select * from pdf where partno='L090XE6S' and brandshort='Knowles Dielectric Labs' limit 1 [ RunTime:0.005254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L090XE6S' OR `brand` LIKE 'Knowles Dielectric Labs%' ) ) LIMIT 1 [ RunTime:0.008733s ]
SELECT `id` FROM `stock` WHERE `id` <> 64161881 AND `partno` = 'L090XE6S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles dielectric labs%' ) [ RunTime:0.003620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64161847 LIMIT 5 [ RunTime:0.013819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64161847 ORDER BY `minOrder` ASC [ RunTime:0.007528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64161847 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64161847 LIMIT 2 [ RunTime:0.001296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64161847 ORDER BY `minOrder` ASC [ RunTime:0.001299s ]
select * from pdf where partno='L095XG4S' and brandshort='Knowles Dielectric Labs' limit 1 [ RunTime:0.001111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L095XG4S' OR `brand` LIKE 'Knowles Dielectric Labs%' ) ) LIMIT 1 [ RunTime:0.012859s ]
SELECT `id` FROM `stock` WHERE `id` <> 64161847 AND `partno` = 'L095XG4S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles dielectric labs%' ) [ RunTime:0.003277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11949796 [ RunTime:0.018824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64161700 LIMIT 5 [ RunTime:0.016119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64161700 ORDER BY `minOrder` ASC [ RunTime:0.004161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64161700 ORDER BY `unit` DESC [ RunTime:0.008573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64161700 LIMIT 2 [ RunTime:0.001596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64161700 ORDER BY `minOrder` ASC [ RunTime:0.005310s ]
select * from pdf where partno='L090XE6S-T' and brandshort='Knowles Dielectric Labs' limit 1 [ RunTime:0.008995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L090XE6S-T' OR `brand` LIKE 'Knowles Dielectric Labs%' ) ) LIMIT 1 [ RunTime:0.010233s ]
SELECT `id` FROM `stock` WHERE `id` <> 64161700 AND `partno` = 'L090XE6S-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles dielectric labs%' ) [ RunTime:0.006034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13216105 [ RunTime:0.005953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64161685 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64161685 ORDER BY `minOrder` ASC [ RunTime:0.006457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64161685 ORDER BY `unit` DESC [ RunTime:0.024294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64161685 LIMIT 2 [ RunTime:0.003964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64161685 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='L095XG4S-T' and brandshort='Knowles Dielectric Labs' limit 1 [ RunTime:0.009101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L095XG4S-T' OR `brand` LIKE 'Knowles Dielectric Labs%' ) ) LIMIT 1 [ RunTime:0.006028s ]
SELECT `id` FROM `stock` WHERE `id` <> 64161685 AND `partno` = 'L095XG4S-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles dielectric labs%' ) [ RunTime:0.001462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13216100 [ RunTime:0.009264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59390755 LIMIT 5 [ RunTime:0.003088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59390755 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59390755 ORDER BY `unit` DESC [ RunTime:0.004008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59390755 LIMIT 2 [ RunTime:0.017797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59390755 ORDER BY `minOrder` ASC [ RunTime:0.001747s ]
select * from pdf where partno='L09' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L09' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001823s ]
SELECT `id` FROM `stock` WHERE `id` <> 59390755 AND `partno` = 'L09' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58248636 LIMIT 5 [ RunTime:0.003428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248636 ORDER BY `minOrder` ASC [ RunTime:0.008182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58248636 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58248636 LIMIT 2 [ RunTime:0.003700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248636 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='L097829' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.001776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L097829' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.005482s ]
SELECT `id` FROM `stock` WHERE `id` <> 58248636 AND `partno` = 'L097829' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.001545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716862 [ RunTime:0.004241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58246951 LIMIT 5 [ RunTime:0.004259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58246951 ORDER BY `minOrder` ASC [ RunTime:0.007415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58246951 ORDER BY `unit` DESC [ RunTime:0.001673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58246951 LIMIT 2 [ RunTime:0.000978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58246951 ORDER BY `minOrder` ASC [ RunTime:0.001369s ]
select * from pdf where partno='L091941' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.007065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L091941' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.000563s ]
SELECT `id` FROM `stock` WHERE `id` <> 58246951 AND `partno` = 'L091941' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825646 [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58246666 LIMIT 5 [ RunTime:0.007861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58246666 ORDER BY `minOrder` ASC [ RunTime:0.009469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58246666 ORDER BY `unit` DESC [ RunTime:0.009357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58246666 LIMIT 2 [ RunTime:0.025317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58246666 ORDER BY `minOrder` ASC [ RunTime:0.002199s ]
select * from pdf where partno='L098979' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.017472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L098979' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.004168s ]
SELECT `id` FROM `stock` WHERE `id` <> 58246666 AND `partno` = 'L098979' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.015341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825580 [ RunTime:0.011670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58246113 LIMIT 5 [ RunTime:0.003637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58246113 ORDER BY `minOrder` ASC [ RunTime:0.002842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58246113 ORDER BY `unit` DESC [ RunTime:0.004056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58246113 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58246113 ORDER BY `minOrder` ASC [ RunTime:0.002732s ]
select * from pdf where partno='L096472' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.013083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L096472' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.027717s ]
SELECT `id` FROM `stock` WHERE `id` <> 58246113 AND `partno` = 'L096472' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.023283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14715994 [ RunTime:0.005561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58245902 LIMIT 5 [ RunTime:0.002921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58245902 ORDER BY `minOrder` ASC [ RunTime:0.001714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58245902 ORDER BY `unit` DESC [ RunTime:0.002231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58245902 LIMIT 2 [ RunTime:0.011525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58245902 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
select * from pdf where partno='L097231' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L097231' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.000597s ]
SELECT `id` FROM `stock` WHERE `id` <> 58245902 AND `partno` = 'L097231' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.003633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825286 [ RunTime:0.029515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58244007 LIMIT 5 [ RunTime:0.022803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58244007 ORDER BY `minOrder` ASC [ RunTime:0.036320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58244007 ORDER BY `unit` DESC [ RunTime:0.012952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58244007 LIMIT 2 [ RunTime:0.007126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58244007 ORDER BY `minOrder` ASC [ RunTime:0.004188s ]
select * from pdf where partno='L098772' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.019536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L098772' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.012216s ]
SELECT `id` FROM `stock` WHERE `id` <> 58244007 AND `partno` = 'L098772' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.018096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16630934 [ RunTime:0.031448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58242399 LIMIT 5 [ RunTime:0.021262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58242399 ORDER BY `minOrder` ASC [ RunTime:0.024202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58242399 ORDER BY `unit` DESC [ RunTime:0.014237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58242399 LIMIT 2 [ RunTime:0.041849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58242399 ORDER BY `minOrder` ASC [ RunTime:0.006789s ]
select * from pdf where partno='L097208' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.014807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L097208' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.021901s ]
SELECT `id` FROM `stock` WHERE `id` <> 58242399 AND `partno` = 'L097208' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.005247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823963 [ RunTime:0.010323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58240182 LIMIT 5 [ RunTime:0.022521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58240182 ORDER BY `minOrder` ASC [ RunTime:0.041085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58240182 ORDER BY `unit` DESC [ RunTime:0.029389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58240182 LIMIT 2 [ RunTime:0.016740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58240182 ORDER BY `minOrder` ASC [ RunTime:0.004426s ]
select * from pdf where partno='L093781' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.025186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L093781' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.010260s ]
SELECT `id` FROM `stock` WHERE `id` <> 58240182 AND `partno` = 'L093781' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.006175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13828806 [ RunTime:0.005539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58237164 LIMIT 5 [ RunTime:0.001243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58237164 ORDER BY `minOrder` ASC [ RunTime:0.033881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58237164 ORDER BY `unit` DESC [ RunTime:0.013384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58237164 LIMIT 2 [ RunTime:0.007673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58237164 ORDER BY `minOrder` ASC [ RunTime:0.005430s ]
select * from pdf where partno='L098105' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.006701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L098105' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.018218s ]
SELECT `id` FROM `stock` WHERE `id` <> 58237164 AND `partno` = 'L098105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.029861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827619 [ RunTime:0.029980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58236733 LIMIT 5 [ RunTime:0.031264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58236733 ORDER BY `minOrder` ASC [ RunTime:0.026258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58236733 ORDER BY `unit` DESC [ RunTime:0.022488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58236733 LIMIT 2 [ RunTime:0.012061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58236733 ORDER BY `minOrder` ASC [ RunTime:0.011736s ]
select * from pdf where partno='L097507' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.013730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L097507' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.010194s ]
SELECT `id` FROM `stock` WHERE `id` <> 58236733 AND `partno` = 'L097507' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.004882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14719023 [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58236715 LIMIT 5 [ RunTime:0.009999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58236715 ORDER BY `minOrder` ASC [ RunTime:0.028162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58236715 ORDER BY `unit` DESC [ RunTime:0.014214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58236715 LIMIT 2 [ RunTime:0.014148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58236715 ORDER BY `minOrder` ASC [ RunTime:0.010168s ]
select * from pdf where partno='L097553' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.005819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L097553' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.003199s ]
SELECT `id` FROM `stock` WHERE `id` <> 58236715 AND `partno` = 'L097553' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.000889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14719082 [ RunTime:0.007634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58235956 LIMIT 5 [ RunTime:0.008171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58235956 ORDER BY `minOrder` ASC [ RunTime:0.002939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58235956 ORDER BY `unit` DESC [ RunTime:0.013256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58235956 LIMIT 2 [ RunTime:0.009105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58235956 ORDER BY `minOrder` ASC [ RunTime:0.001412s ]
select * from pdf where partno='L098128' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.006232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L098128' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.001122s ]
SELECT `id` FROM `stock` WHERE `id` <> 58235956 AND `partno` = 'L098128' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.000984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827247 [ RunTime:0.008215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58235636 LIMIT 5 [ RunTime:0.006753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58235636 ORDER BY `minOrder` ASC [ RunTime:0.010002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58235636 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58235636 LIMIT 2 [ RunTime:0.007937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58235636 ORDER BY `minOrder` ASC [ RunTime:0.011184s ]
select * from pdf where partno='L093321' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.005549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L093321' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.000866s ]
SELECT `id` FROM `stock` WHERE `id` <> 58235636 AND `partno` = 'L093321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.000928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718642 [ RunTime:0.003448s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009388s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006332s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001132s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001124s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005901s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001094s ]
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 'L09%' OR `brand` LIKE 'L09%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010385s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'L09%' OR `brand` LIKE 'L09%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006086s ]