SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003150s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013807s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160172 LIMIT 5 [ RunTime:0.000728s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160172 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12160172 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12160172 LIMIT 2 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160172 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160175 LIMIT 5 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160175 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12160175 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12160175 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160175 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12444887 LIMIT 5 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12444887 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12444887 ORDER BY `unit` DESC [ RunTime:0.000274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12444887 LIMIT 2 [ RunTime:0.000312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12444887 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15311208 LIMIT 5 [ RunTime:0.002665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311208 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15311208 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15311208 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311208 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447868 LIMIT 5 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447868 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447868 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447868 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447868 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447822 LIMIT 5 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447822 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447822 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447822 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447822 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447821 LIMIT 5 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447821 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447821 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447821 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447821 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447820 LIMIT 5 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447820 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447820 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447820 LIMIT 2 [ RunTime:0.000274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447820 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447819 LIMIT 5 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447819 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447819 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447819 LIMIT 2 [ RunTime:0.000274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447819 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447794 LIMIT 5 [ RunTime:0.001161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447794 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447794 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447794 LIMIT 2 [ RunTime:0.001723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447794 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447793 LIMIT 5 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447793 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447793 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447793 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447793 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447792 LIMIT 5 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447792 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447792 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447792 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447792 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447791 LIMIT 5 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447791 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447791 ORDER BY `unit` DESC [ RunTime:0.000282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447791 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447791 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447766 LIMIT 5 [ RunTime:0.003941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447766 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447766 ORDER BY `unit` DESC [ RunTime:0.000296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447766 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447766 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447765 LIMIT 5 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447765 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447765 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447765 LIMIT 2 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447765 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447764 LIMIT 5 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447764 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447764 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447764 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447764 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447763 LIMIT 5 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447763 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447763 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447763 LIMIT 2 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447763 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447762 LIMIT 5 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447762 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447762 ORDER BY `unit` DESC [ RunTime:0.000279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447762 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447762 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447761 LIMIT 5 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447761 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447761 ORDER BY `unit` DESC [ RunTime:0.000287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447761 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447761 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447760 LIMIT 5 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447760 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447760 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447760 LIMIT 2 [ RunTime:0.000269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447760 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51099679 LIMIT 5 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51099679 ORDER BY `minOrder` ASC [ RunTime:0.001699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51099679 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51099679 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51099679 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
select * from pdf where partno='lt-1' and brandshort='apex tool group' limit 1 [ RunTime:0.000541s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'lt-1' OR `brand` LIKE 'apex tool group%' ) ) LIMIT 1 [ RunTime:0.000618s ]
SELECT `id` FROM `stock` WHERE `id` <> 51099679 AND `partno` = 'lt-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.000440s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65403030 LIMIT 5 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65403030 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65403030 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65403030 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65403030 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='LT-103H' and brandshort='Ideal-tek S.A.' limit 1 [ RunTime:0.000518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-103H' OR `brand` LIKE 'Ideal-tek S.A.%' ) ) LIMIT 1 [ RunTime:0.000372s ]
SELECT `id` FROM `stock` WHERE `id` <> 65403030 AND `partno` = 'LT-103H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ideal-tek s.a.%' ) [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160172 [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65403032 LIMIT 5 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65403032 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65403032 ORDER BY `unit` DESC [ RunTime:0.000284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65403032 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65403032 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='LT-105H' and brandshort='Ideal-tek S.A.' limit 1 [ RunTime:0.000455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-105H' OR `brand` LIKE 'Ideal-tek S.A.%' ) ) LIMIT 1 [ RunTime:0.000352s ]
SELECT `id` FROM `stock` WHERE `id` <> 65403032 AND `partno` = 'LT-105H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ideal-tek s.a.%' ) [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160175 [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65230429 LIMIT 5 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230429 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65230429 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65230429 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230429 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='LT-1581-601-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1581-601-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000406s ]
SELECT `id` FROM `stock` WHERE `id` <> 65230429 AND `partno` = 'LT-1581-601-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12444895 [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65230432 LIMIT 5 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230432 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65230432 ORDER BY `unit` DESC [ RunTime:0.000288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65230432 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230432 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='LT-1511-710-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.001285s ]
select foldpath,foldpath2,filename from pdf_file where id=1485707 limit 1 [ RunTime:0.000426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1511-710-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000395s ]
SELECT `id` FROM `stock` WHERE `id` <> 65230432 AND `partno` = 'LT-1511-710-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12444887 [ RunTime:0.000328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65230428 LIMIT 5 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230428 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65230428 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65230428 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230428 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='LT-1531-610-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.004502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1531-610-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 65230428 AND `partno` = 'LT-1531-610-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11363303 [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65230427 LIMIT 5 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230427 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65230427 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65230427 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230427 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='LT-1531-601-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1531-601-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000385s ]
SELECT `id` FROM `stock` WHERE `id` <> 65230427 AND `partno` = 'LT-1531-601-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12444893 [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65230426 LIMIT 5 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230426 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65230426 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65230426 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65230426 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='LT-1511-630-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.001767s ]
select foldpath,foldpath2,filename from pdf_file where id=1485707 limit 1 [ RunTime:0.000309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1511-630-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000394s ]
SELECT `id` FROM `stock` WHERE `id` <> 65230426 AND `partno` = 'LT-1511-630-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65232787 LIMIT 5 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65232787 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65232787 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65232787 LIMIT 2 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65232787 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='LT-1511-110-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1511-110-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000390s ]
SELECT `id` FROM `stock` WHERE `id` <> 65232787 AND `partno` = 'LT-1511-110-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70289449 LIMIT 5 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70289449 ORDER BY `minOrder` ASC [ RunTime:0.000893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70289449 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70289449 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70289449 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='LT-100' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.000751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-100' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.000325s ]
SELECT `id` FROM `stock` WHERE `id` <> 70289449 AND `partno` = 'LT-100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11182108 [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70289227 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70289227 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70289227 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70289227 LIMIT 2 [ RunTime:0.000232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70289227 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
select * from pdf where partno='LT-10-ANT' and brandshort='Amprobe' limit 1 [ RunTime:0.000412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-10-ANT' OR `brand` LIKE 'Amprobe%' ) ) LIMIT 1 [ RunTime:0.000513s ]
SELECT `id` FROM `stock` WHERE `id` <> 70289227 AND `partno` = 'LT-10-ANT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amprobe%' ) [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11182823 [ RunTime:0.005092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65408777 LIMIT 5 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65408777 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65408777 ORDER BY `unit` DESC [ RunTime:0.000306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65408777 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65408777 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='LT-1' and brandshort='EDSYN INCORPORATED' limit 1 [ RunTime:0.000397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1' OR `brand` LIKE 'EDSYN INCORPORATED%' ) ) LIMIT 1 [ RunTime:0.000515s ]
SELECT `id` FROM `stock` WHERE `id` <> 65408777 AND `partno` = 'LT-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%edsyn incorporated%' ) [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239347 LIMIT 5 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239347 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239347 ORDER BY `unit` DESC [ RunTime:0.000265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239347 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239347 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='LT-1585-513-024' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1585-513-024' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000395s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239347 AND `partno` = 'LT-1585-513-024' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239346 LIMIT 5 [ RunTime:0.000255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239346 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239346 ORDER BY `unit` DESC [ RunTime:0.000244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239346 LIMIT 2 [ RunTime:0.000229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239346 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='LT-1585-513-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1585-513-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000339s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239346 AND `partno` = 'LT-1585-513-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447868 [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239272 LIMIT 5 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239272 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239272 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239272 LIMIT 2 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239272 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='LT-1585-601-250' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1585-601-250' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000379s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239272 AND `partno` = 'LT-1585-601-250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239168 LIMIT 5 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239168 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239168 ORDER BY `unit` DESC [ RunTime:0.000281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239168 LIMIT 2 [ RunTime:0.000265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239168 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='LT-1535-510-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000629s ]
select foldpath,foldpath2,filename from pdf_file where id=1485707 limit 1 [ RunTime:0.000300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1535-510-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000405s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239168 AND `partno` = 'LT-1535-510-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239162 LIMIT 5 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239162 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239162 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239162 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239162 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='LT-1535-610-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.001093s ]
select foldpath,foldpath2,filename from pdf_file where id=1485707 limit 1 [ RunTime:0.000294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1535-610-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000355s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239162 AND `partno` = 'LT-1535-610-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11365208 [ RunTime:0.000606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239127 LIMIT 5 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239127 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239127 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239127 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239127 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='LT-1584-501-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1584-501-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000389s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239127 AND `partno` = 'LT-1584-501-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447819 [ RunTime:0.000312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239126 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239126 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239126 ORDER BY `unit` DESC [ RunTime:0.000296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239126 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239126 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='LT-1565-645-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.001627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1565-645-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000345s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239126 AND `partno` = 'LT-1565-645-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239125 LIMIT 5 [ RunTime:0.000312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239125 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239125 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239125 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239125 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='LT-1565-601-012' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000626s ]
select foldpath,foldpath2,filename from pdf_file where id=1485707 limit 1 [ RunTime:0.000390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1565-601-012' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000417s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239125 AND `partno` = 'LT-1565-601-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65239124 LIMIT 5 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239124 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65239124 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65239124 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65239124 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='LT-1554-632-012/SC BULK' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT-1554-632-012/SC BULK' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000580s ]
SELECT `id` FROM `stock` WHERE `id` <> 65239124 AND `partno` = 'LT-1554-632-012/SC BULK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000565s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001111s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001031s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001026s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000839s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000869s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000859s ]
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 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000923s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'lt-1%' OR `brand` LIKE 'lt-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003469s ]