SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001275s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014742s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15292872 LIMIT 5 [ RunTime:0.012308s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15292872 ORDER BY `minOrder` ASC [ RunTime:0.002585s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15292872 ORDER BY `unit` DESC [ RunTime:0.014977s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15292872 LIMIT 2 [ RunTime:0.003757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15292872 ORDER BY `minOrder` ASC [ RunTime:0.006090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15292874 LIMIT 5 [ RunTime:0.003308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15292874 ORDER BY `minOrder` ASC [ RunTime:0.028788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15292874 ORDER BY `unit` DESC [ RunTime:0.007374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15292874 LIMIT 2 [ RunTime:0.016822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15292874 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19078349 LIMIT 5 [ RunTime:0.009669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19078349 ORDER BY `minOrder` ASC [ RunTime:0.015918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19078349 ORDER BY `unit` DESC [ RunTime:0.024898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19078349 LIMIT 2 [ RunTime:0.017647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19078349 ORDER BY `minOrder` ASC [ RunTime:0.005961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19078232 LIMIT 5 [ RunTime:0.027682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19078232 ORDER BY `minOrder` ASC [ RunTime:0.010681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19078232 ORDER BY `unit` DESC [ RunTime:0.021440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19078232 LIMIT 2 [ RunTime:0.016956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19078232 ORDER BY `minOrder` ASC [ RunTime:0.015027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16036408 LIMIT 5 [ RunTime:0.011092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16036408 ORDER BY `minOrder` ASC [ RunTime:0.019446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16036408 ORDER BY `unit` DESC [ RunTime:0.022064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16036408 LIMIT 2 [ RunTime:0.019949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16036408 ORDER BY `minOrder` ASC [ RunTime:0.005713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16036407 LIMIT 5 [ RunTime:0.004014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16036407 ORDER BY `minOrder` ASC [ RunTime:0.014053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16036407 ORDER BY `unit` DESC [ RunTime:0.024387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16036407 LIMIT 2 [ RunTime:0.033563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16036407 ORDER BY `minOrder` ASC [ RunTime:0.011649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16032144 LIMIT 5 [ RunTime:0.013770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16032144 ORDER BY `minOrder` ASC [ RunTime:0.002361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16032144 ORDER BY `unit` DESC [ RunTime:0.001056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16032144 LIMIT 2 [ RunTime:0.003730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16032144 ORDER BY `minOrder` ASC [ RunTime:0.001623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14217909 LIMIT 5 [ RunTime:0.002766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14217909 ORDER BY `minOrder` ASC [ RunTime:0.004167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14217909 ORDER BY `unit` DESC [ RunTime:0.004389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14217909 LIMIT 2 [ RunTime:0.003864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14217909 ORDER BY `minOrder` ASC [ RunTime:0.008967s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51047423 LIMIT 5 [ RunTime:0.001396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51047423 ORDER BY `minOrder` ASC [ RunTime:0.001498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51047423 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51047423 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51047423 ORDER BY `minOrder` ASC [ RunTime:0.001644s ]
select * from pdf where partno='tl7705acd' and brandshort='texas instruments' limit 1 [ RunTime:0.015684s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tl7705acd' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.004518s ]
SELECT `id` FROM `stock` WHERE `id` <> 51047423 AND `partno` = 'tl7705acd' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.015337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15292874 [ RunTime:0.002644s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56820994 LIMIT 5 [ RunTime:0.001907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56820994 ORDER BY `minOrder` ASC [ RunTime:0.002583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56820994 ORDER BY `unit` DESC [ RunTime:0.006011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56820994 LIMIT 2 [ RunTime:0.004683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56820994 ORDER BY `minOrder` ASC [ RunTime:0.007427s ]
select * from pdf where partno='TL7705ACD' and brandshort='Texas Instruments' limit 1 [ RunTime:0.005250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL7705ACD' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.004345s ]
SELECT `id` FROM `stock` WHERE `id` <> 56820994 AND `partno` = 'TL7705ACD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15292874 [ RunTime:0.002884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56820289 LIMIT 5 [ RunTime:0.002714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56820289 ORDER BY `minOrder` ASC [ RunTime:0.005335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56820289 ORDER BY `unit` DESC [ RunTime:0.003954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56820289 LIMIT 2 [ RunTime:0.004393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56820289 ORDER BY `minOrder` ASC [ RunTime:0.004606s ]
select * from pdf where partno='TL7705ACDR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.008522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL7705ACDR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005548s ]
SELECT `id` FROM `stock` WHERE `id` <> 56820289 AND `partno` = 'TL7705ACDR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15292872 [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56849990 LIMIT 5 [ RunTime:0.004302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56849990 ORDER BY `minOrder` ASC [ RunTime:0.005956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56849990 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56849990 LIMIT 2 [ RunTime:0.000317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56849990 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
select * from pdf where partno='TL7705ACDG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.006406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL7705ACDG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003938s ]
SELECT `id` FROM `stock` WHERE `id` <> 56849990 AND `partno` = 'TL7705ACDG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.007277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16036408 [ RunTime:0.006565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56849989 LIMIT 5 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56849989 ORDER BY `minOrder` ASC [ RunTime:0.011359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56849989 ORDER BY `unit` DESC [ RunTime:0.013469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56849989 LIMIT 2 [ RunTime:0.007802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56849989 ORDER BY `minOrder` ASC [ RunTime:0.005493s ]
select * from pdf where partno='TL7705ACDE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL7705ACDE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003263s ]
SELECT `id` FROM `stock` WHERE `id` <> 56849989 AND `partno` = 'TL7705ACDE4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.001104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16036407 [ RunTime:0.015762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56849661 LIMIT 5 [ RunTime:0.021179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56849661 ORDER BY `minOrder` ASC [ RunTime:0.018515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56849661 ORDER BY `unit` DESC [ RunTime:0.015399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56849661 LIMIT 2 [ RunTime:0.005574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56849661 ORDER BY `minOrder` ASC [ RunTime:0.010906s ]
select * from pdf where partno='TL7705ACDRG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL7705ACDRG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002467s ]
SELECT `id` FROM `stock` WHERE `id` <> 56849661 AND `partno` = 'TL7705ACDRG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.007493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14217909 [ RunTime:0.008108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56837015 LIMIT 5 [ RunTime:0.020035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56837015 ORDER BY `minOrder` ASC [ RunTime:0.001392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56837015 ORDER BY `unit` DESC [ RunTime:0.000538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56837015 LIMIT 2 [ RunTime:0.004641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56837015 ORDER BY `minOrder` ASC [ RunTime:0.019834s ]
select * from pdf where partno='TL7705ACD1/A' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.010088s ]
select foldpath,foldpath2,filename from pdf_file where id=1324703 limit 1 [ RunTime:0.001927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL7705ACD1/A' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.001885s ]
SELECT `id` FROM `stock` WHERE `id` <> 56837015 AND `partno` = 'TL7705ACD1/A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.001902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19078349 [ RunTime:0.003729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56836897 LIMIT 5 [ RunTime:0.004613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56836897 ORDER BY `minOrder` ASC [ RunTime:0.019128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56836897 ORDER BY `unit` DESC [ RunTime:0.014288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56836897 LIMIT 2 [ RunTime:0.018849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56836897 ORDER BY `minOrder` ASC [ RunTime:0.004037s ]
select * from pdf where partno='TL7705ACD1013TRA' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.001460s ]
select foldpath,foldpath2,filename from pdf_file where id=1060041 limit 1 [ RunTime:0.004208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL7705ACD1013TRA' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.003759s ]
SELECT `id` FROM `stock` WHERE `id` <> 56836897 AND `partno` = 'TL7705ACD1013TRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.011943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19078232 [ RunTime:0.006294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56830022 LIMIT 5 [ RunTime:0.002752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56830022 ORDER BY `minOrder` ASC [ RunTime:0.030879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56830022 ORDER BY `unit` DESC [ RunTime:0.005922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56830022 LIMIT 2 [ RunTime:0.008676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56830022 ORDER BY `minOrder` ASC [ RunTime:0.009952s ]
select * from pdf where partno='TL7705ACDRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.004761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL7705ACDRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003625s ]
SELECT `id` FROM `stock` WHERE `id` <> 56830022 AND `partno` = 'TL7705ACDRE4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.008375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16032144 [ RunTime:0.015045s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023020s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010847s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009323s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018112s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015161s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017175s ]
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 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014028s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TL7705ACD%' OR `brand` LIKE 'TL7705ACD%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005826s ]