SHOW FULL COLUMNS FROM `stock` [ 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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004362s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12381326 LIMIT 5 [ RunTime:0.003476s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12381326 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12381326 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12381326 LIMIT 2 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12381326 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11983897 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11983897 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11983897 ORDER BY `unit` DESC [ RunTime:0.000271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11983897 LIMIT 2 [ RunTime:0.000221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11983897 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13253930 LIMIT 5 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13253930 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13253930 ORDER BY `unit` DESC [ RunTime:0.000225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13253930 LIMIT 2 [ RunTime:0.000229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13253930 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480328 LIMIT 5 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480328 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480328 ORDER BY `unit` DESC [ RunTime:0.000236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480328 LIMIT 2 [ RunTime:0.000225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480328 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
select * from pdf where partno='FD2500104' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480327 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480327 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480327 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480327 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480327 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480326 LIMIT 5 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480326 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480326 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480326 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480326 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='FD2500099' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480325 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480325 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480325 ORDER BY `unit` DESC [ RunTime:0.000441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480325 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480325 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480324 LIMIT 5 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480324 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480324 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480324 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480324 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480323 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480323 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480323 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480323 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480323 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='FD2500075' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480322 LIMIT 5 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480322 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480322 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480322 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480322 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480321 LIMIT 5 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480321 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480321 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480321 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480321 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='FD2500048' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480320 LIMIT 5 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480320 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480320 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480320 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480320 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480291 LIMIT 5 [ RunTime:0.001999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480291 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480291 ORDER BY `unit` DESC [ RunTime:0.000311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480291 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480291 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='FD2500063' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480290 LIMIT 5 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480290 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480290 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480290 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480290 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='FD2500061' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480289 LIMIT 5 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480289 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480289 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480289 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480289 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480288 LIMIT 5 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480288 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480288 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480288 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480288 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480287 LIMIT 5 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480287 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19480287 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19480287 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19480287 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19474271 LIMIT 5 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19474271 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19474271 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19474271 LIMIT 2 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19474271 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19469532 LIMIT 5 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19469532 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19469532 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19469532 LIMIT 2 [ RunTime:0.000223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19469532 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
select * from pdf where partno='FD2500068' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17254689 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17254689 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17254689 ORDER BY `unit` DESC [ RunTime:0.000275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17254689 LIMIT 2 [ RunTime:0.000265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17254689 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='FD2500060' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000409s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129830 LIMIT 5 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129830 ORDER BY `minOrder` ASC [ RunTime:0.001339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129830 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129830 LIMIT 2 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129830 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
select * from pdf where partno='fd2500090' and brandshort='diodes incorporated' limit 1 [ RunTime:0.001067s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'fd2500090' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.001047s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129830 AND `partno` = 'fd2500090' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.001009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480324 [ RunTime:0.000634s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42872300 LIMIT 5 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42872300 ORDER BY `minOrder` ASC [ RunTime:0.003518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42872300 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42872300 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42872300 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
select * from pdf where partno='FD2500054' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500054' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000757s ]
SELECT `id` FROM `stock` WHERE `id` <> 42872300 AND `partno` = 'FD2500054' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12381326 [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70965650 LIMIT 5 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70965650 ORDER BY `minOrder` ASC [ RunTime:0.001165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70965650 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70965650 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70965650 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='FD25' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.000773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD25' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.000874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70966027 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70966027 ORDER BY `minOrder` ASC [ RunTime:0.000978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70966027 ORDER BY `unit` DESC [ RunTime:0.000510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70966027 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70966027 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='FD25H' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.000488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD25H' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.000588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70966098 LIMIT 5 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70966098 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70966098 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70966098 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70966098 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='FD25E' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.000608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD25E' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70967152 LIMIT 5 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70967152 ORDER BY `minOrder` ASC [ RunTime:0.002649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70967152 ORDER BY `unit` DESC [ RunTime:0.000534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70967152 LIMIT 2 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70967152 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='FD25HC' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.000998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD25HC' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.000764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70967144 LIMIT 5 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70967144 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70967144 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70967144 LIMIT 2 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70967144 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
select * from pdf where partno='FD25C' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.000818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD25C' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.000736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70931223 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70931223 ORDER BY `minOrder` ASC [ RunTime:0.003444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70931223 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70931223 LIMIT 2 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70931223 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='FD25B2480' and brandshort='Leader Tech Inc.' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD25B2480' OR `brand` LIKE 'Leader Tech Inc.%' ) ) LIMIT 1 [ RunTime:0.000744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65527491 LIMIT 5 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65527491 ORDER BY `minOrder` ASC [ RunTime:0.001994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65527491 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65527491 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65527491 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='FD250R65KE3KNOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.000805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD250R65KE3KNOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000722s ]
SELECT `id` FROM `stock` WHERE `id` <> 65527491 AND `partno` = 'FD250R65KE3KNOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43608841 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43608841 ORDER BY `minOrder` ASC [ RunTime:0.001182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43608841 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43608841 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43608841 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='FD2500099' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500099' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT `id` FROM `stock` WHERE `id` <> 43608841 AND `partno` = 'FD2500099' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480326 [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43608840 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43608840 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43608840 ORDER BY `unit` DESC [ RunTime:0.000385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43608840 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43608840 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='FD2500048' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500048' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000491s ]
SELECT `id` FROM `stock` WHERE `id` <> 43608840 AND `partno` = 'FD2500048' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480321 [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43608839 LIMIT 5 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43608839 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43608839 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43608839 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43608839 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='FD2500044' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500044' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000519s ]
SELECT `id` FROM `stock` WHERE `id` <> 43608839 AND `partno` = 'FD2500044' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480320 [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43608835 LIMIT 5 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43608835 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43608835 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43608835 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43608835 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='FD2500060' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500060' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000525s ]
SELECT `id` FROM `stock` WHERE `id` <> 43608835 AND `partno` = 'FD2500060' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17254689 [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43487138 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43487138 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43487138 ORDER BY `unit` DESC [ RunTime:0.000312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43487138 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43487138 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='FD2500100' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500100' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000398s ]
SELECT `id` FROM `stock` WHERE `id` <> 43487138 AND `partno` = 'FD2500100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480327 [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43487137 LIMIT 5 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43487137 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43487137 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43487137 LIMIT 2 [ RunTime:0.000265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43487137 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
select * from pdf where partno='FD2500093' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500093' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000409s ]
SELECT `id` FROM `stock` WHERE `id` <> 43487137 AND `partno` = 'FD2500093' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480325 [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43487126 LIMIT 5 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43487126 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43487126 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43487126 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43487126 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='FD2500049' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500049' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000930s ]
SELECT `id` FROM `stock` WHERE `id` <> 43487126 AND `partno` = 'FD2500049' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480287 [ RunTime:0.000556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43281264 LIMIT 5 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43281264 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43281264 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43281264 LIMIT 2 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43281264 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='FD2500084' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500084' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000600s ]
SELECT `id` FROM `stock` WHERE `id` <> 43281264 AND `partno` = 'FD2500084' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15420231 [ RunTime:0.000986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43281256 LIMIT 5 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43281256 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43281256 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43281256 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43281256 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='FD2500063' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500063' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000601s ]
SELECT `id` FROM `stock` WHERE `id` <> 43281256 AND `partno` = 'FD2500063' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480291 [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43281255 LIMIT 5 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43281255 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43281255 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43281255 LIMIT 2 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43281255 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='FD2500050' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500050' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000656s ]
SELECT `id` FROM `stock` WHERE `id` <> 43281255 AND `partno` = 'FD2500050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480288 [ RunTime:0.000512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43081443 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43081443 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43081443 ORDER BY `unit` DESC [ RunTime:0.000466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43081443 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43081443 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='FD2500075' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500075' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000584s ]
SELECT `id` FROM `stock` WHERE `id` <> 43081443 AND `partno` = 'FD2500075' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480323 [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42991828 LIMIT 5 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42991828 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42991828 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42991828 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42991828 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
select * from pdf where partno='FD2500061' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FD2500061' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000488s ]
SELECT `id` FROM `stock` WHERE `id` <> 42991828 AND `partno` = 'FD2500061' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19480290 [ RunTime:0.000432s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001073s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000820s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000797s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000899s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000791s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000785s ]
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 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000930s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FD25%' OR `brand` LIKE 'FD25%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001055s ]