SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003539s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.177' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=LFA240F-24-S&search=1' [ RunTime:0.021720s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.007811s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006364s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003924s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.177' ) [ RunTime:0.008408s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003284s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004284s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002591s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LFA240F-24-S' LIMIT 1 [ RunTime:0.024473s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 09:53:16' WHERE `partno` = 'LFA240F-24-S' [ RunTime:0.017322s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003248s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078074s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.033051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12110987 LIMIT 5 [ RunTime:0.078216s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12110987 ORDER BY `minOrder` ASC [ RunTime:0.081753s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12110987 ORDER BY `unit` DESC [ RunTime:0.085020s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.021074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12110987 LIMIT 2 [ RunTime:0.081488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12110987 ORDER BY `minOrder` ASC [ RunTime:0.027426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086297 LIMIT 5 [ RunTime:0.080383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086297 ORDER BY `minOrder` ASC [ RunTime:0.090049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086297 ORDER BY `unit` DESC [ RunTime:0.041187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086297 LIMIT 2 [ RunTime:0.040491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086297 ORDER BY `minOrder` ASC [ RunTime:0.028618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086258 LIMIT 5 [ RunTime:0.056002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086258 ORDER BY `minOrder` ASC [ RunTime:0.034848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086258 ORDER BY `unit` DESC [ RunTime:0.047972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086258 LIMIT 2 [ RunTime:0.025245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086258 ORDER BY `minOrder` ASC [ RunTime:0.011797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086231 LIMIT 5 [ RunTime:0.014917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086231 ORDER BY `minOrder` ASC [ RunTime:0.019513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086231 ORDER BY `unit` DESC [ RunTime:0.020982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086231 LIMIT 2 [ RunTime:0.015753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086231 ORDER BY `minOrder` ASC [ RunTime:0.027349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086159 LIMIT 5 [ RunTime:0.043960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086159 ORDER BY `minOrder` ASC [ RunTime:0.055732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086159 ORDER BY `unit` DESC [ RunTime:0.025736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086159 LIMIT 2 [ RunTime:0.005765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086159 ORDER BY `minOrder` ASC [ RunTime:0.002941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086147 LIMIT 5 [ RunTime:0.005887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086147 ORDER BY `minOrder` ASC [ RunTime:0.025698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086147 ORDER BY `unit` DESC [ RunTime:0.014794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086147 LIMIT 2 [ RunTime:0.003000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086147 ORDER BY `minOrder` ASC [ RunTime:0.003969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086132 LIMIT 5 [ RunTime:0.008527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086132 ORDER BY `minOrder` ASC [ RunTime:0.008277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086132 ORDER BY `unit` DESC [ RunTime:0.006720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086132 LIMIT 2 [ RunTime:0.012059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086132 ORDER BY `minOrder` ASC [ RunTime:0.002003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086131 LIMIT 5 [ RunTime:0.003046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086131 ORDER BY `minOrder` ASC [ RunTime:0.007125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086131 ORDER BY `unit` DESC [ RunTime:0.009502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086131 LIMIT 2 [ RunTime:0.003416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086131 ORDER BY `minOrder` ASC [ RunTime:0.003425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086097 LIMIT 5 [ RunTime:0.009951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086097 ORDER BY `minOrder` ASC [ RunTime:0.003812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086097 ORDER BY `unit` DESC [ RunTime:0.020216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086097 LIMIT 2 [ RunTime:0.006444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086097 ORDER BY `minOrder` ASC [ RunTime:0.001421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086087 LIMIT 5 [ RunTime:0.003916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086087 ORDER BY `minOrder` ASC [ RunTime:0.005764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086087 ORDER BY `unit` DESC [ RunTime:0.008954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086087 LIMIT 2 [ RunTime:0.013864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086087 ORDER BY `minOrder` ASC [ RunTime:0.002551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086086 LIMIT 5 [ RunTime:0.004573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086086 ORDER BY `minOrder` ASC [ RunTime:0.011296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12086086 ORDER BY `unit` DESC [ RunTime:0.013823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12086086 LIMIT 2 [ RunTime:0.012391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12086086 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12081596 LIMIT 5 [ RunTime:0.003889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12081596 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12081596 ORDER BY `unit` DESC [ RunTime:0.008639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12081596 LIMIT 2 [ RunTime:0.004800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12081596 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130516 LIMIT 5 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130516 ORDER BY `minOrder` ASC [ RunTime:0.001049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11130516 ORDER BY `unit` DESC [ RunTime:0.001022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11130516 LIMIT 2 [ RunTime:0.003021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130516 ORDER BY `minOrder` ASC [ RunTime:0.001223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130438 LIMIT 5 [ RunTime:0.003787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130438 ORDER BY `minOrder` ASC [ RunTime:0.003114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11130438 ORDER BY `unit` DESC [ RunTime:0.005094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11130438 LIMIT 2 [ RunTime:0.003838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130438 ORDER BY `minOrder` ASC [ RunTime:0.001558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130432 LIMIT 5 [ RunTime:0.003972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130432 ORDER BY `minOrder` ASC [ RunTime:0.004847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11130432 ORDER BY `unit` DESC [ RunTime:0.005137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11130432 LIMIT 2 [ RunTime:0.006196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130432 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32169586 LIMIT 5 [ RunTime:0.006975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32169586 ORDER BY `minOrder` ASC [ RunTime:0.002629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32169586 ORDER BY `unit` DESC [ RunTime:0.006773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32169586 LIMIT 2 [ RunTime:0.009441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32169586 ORDER BY `minOrder` ASC [ RunTime:0.000955s ]
select * from pdf where partno='lfa240f-24-sn' and brandshort='cosel' limit 1 [ RunTime:0.003338s ]
select foldpath,foldpath2,filename from pdf_file where id=1918603 limit 1 [ RunTime:0.006506s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'lfa240f-24-sn' OR `brand` LIKE 'cosel%' ) ) LIMIT 1 [ RunTime:0.001559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51076928 LIMIT 5 [ RunTime:0.002756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076928 ORDER BY `minOrder` ASC [ RunTime:0.001551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51076928 ORDER BY `unit` DESC [ RunTime:0.005547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51076928 LIMIT 2 [ RunTime:0.006134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076928 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='lfa240f-24-sty' and brandshort='cosel' limit 1 [ RunTime:0.001997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'lfa240f-24-sty' OR `brand` LIKE 'cosel%' ) ) LIMIT 1 [ RunTime:0.002581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51076927 LIMIT 5 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076927 ORDER BY `minOrder` ASC [ RunTime:0.001392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51076927 ORDER BY `unit` DESC [ RunTime:0.004976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51076927 LIMIT 2 [ RunTime:0.001665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076927 ORDER BY `minOrder` ASC [ RunTime:0.001088s ]
select * from pdf where partno='lfa240f-24-snr' and brandshort='cosel' limit 1 [ RunTime:0.006067s ]
select foldpath,foldpath2,filename from pdf_file where id=1918603 limit 1 [ RunTime:0.002116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'lfa240f-24-snr' OR `brand` LIKE 'cosel%' ) ) LIMIT 1 [ RunTime:0.003081s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41600443 LIMIT 5 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41600443 ORDER BY `minOrder` ASC [ RunTime:0.005399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41600443 ORDER BY `unit` DESC [ RunTime:0.003657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41600443 LIMIT 2 [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41600443 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='LFA240F-24-SN' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.006423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SN' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.008744s ]
SELECT `id` FROM `stock` WHERE `id` <> 41600443 AND `partno` = 'LFA240F-24-SN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.041885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12081596 [ RunTime:0.016675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41611137 LIMIT 5 [ RunTime:0.008988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41611137 ORDER BY `minOrder` ASC [ RunTime:0.020010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41611137 ORDER BY `unit` DESC [ RunTime:0.017670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41611137 LIMIT 2 [ RunTime:0.012658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41611137 ORDER BY `minOrder` ASC [ RunTime:0.000993s ]
select * from pdf where partno='LFA240F-24-SNY' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.007512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNY' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.002848s ]
SELECT `id` FROM `stock` WHERE `id` <> 41611137 AND `partno` = 'LFA240F-24-SNY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12110987 [ RunTime:0.008136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633677 LIMIT 5 [ RunTime:0.002509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633677 ORDER BY `minOrder` ASC [ RunTime:0.019624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633677 ORDER BY `unit` DESC [ RunTime:0.004168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633677 LIMIT 2 [ RunTime:0.002354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633677 ORDER BY `minOrder` ASC [ RunTime:0.000792s ]
select * from pdf where partno='LFA240F-24-SNC' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.006849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNC' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.011504s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633677 AND `partno` = 'LFA240F-24-SNC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.005999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086297 [ RunTime:0.008637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633617 LIMIT 5 [ RunTime:0.004004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633617 ORDER BY `minOrder` ASC [ RunTime:0.007750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633617 ORDER BY `unit` DESC [ RunTime:0.005015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633617 LIMIT 2 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633617 ORDER BY `minOrder` ASC [ RunTime:0.004321s ]
select * from pdf where partno='LFA240F-24-SNT' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.003976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNT' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001547s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633617 AND `partno` = 'LFA240F-24-SNT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.002743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086258 [ RunTime:0.009068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633390 LIMIT 5 [ RunTime:0.001962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633390 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633390 ORDER BY `unit` DESC [ RunTime:0.003270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633390 LIMIT 2 [ RunTime:0.004052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633390 ORDER BY `minOrder` ASC [ RunTime:0.006395s ]
select * from pdf where partno='LFA240F-24-SNRY' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.007037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNRY' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.003707s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633390 AND `partno` = 'LFA240F-24-SNRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.006053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130516 [ RunTime:0.000761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633389 LIMIT 5 [ RunTime:0.010907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633389 ORDER BY `minOrder` ASC [ RunTime:0.002644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633389 ORDER BY `unit` DESC [ RunTime:0.004905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633389 LIMIT 2 [ RunTime:0.009060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633389 ORDER BY `minOrder` ASC [ RunTime:0.004054s ]
select * from pdf where partno='LFA240F-24-SC' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SC' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001339s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633389 AND `partno` = 'LFA240F-24-SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.008488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086231 [ RunTime:0.003987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633337 LIMIT 5 [ RunTime:0.005133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633337 ORDER BY `minOrder` ASC [ RunTime:0.004175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633337 ORDER BY `unit` DESC [ RunTime:0.002726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633337 LIMIT 2 [ RunTime:0.003408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633337 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='LFA240F-24-SNR2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.005505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNR2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000851s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633337 AND `partno` = 'LFA240F-24-SNR2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.003023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633336 LIMIT 5 [ RunTime:0.006729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633336 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633336 ORDER BY `unit` DESC [ RunTime:0.004904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633336 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633336 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
select * from pdf where partno='LFA240F-24-SNR' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.006847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNR' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.004866s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633336 AND `partno` = 'LFA240F-24-SNR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.004534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633296 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633296 ORDER BY `minOrder` ASC [ RunTime:0.001566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633296 ORDER BY `unit` DESC [ RunTime:0.004174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633296 LIMIT 2 [ RunTime:0.002307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633296 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='LFA240F-24-ST' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.004687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-ST' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.006677s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633296 AND `partno` = 'LFA240F-24-ST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.005130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086159 [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633070 LIMIT 5 [ RunTime:0.002644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633070 ORDER BY `minOrder` ASC [ RunTime:0.006628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633070 ORDER BY `unit` DESC [ RunTime:0.005316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633070 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633070 ORDER BY `minOrder` ASC [ RunTime:0.003359s ]
select * from pdf where partno='LFA240F-24-STY' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.006940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-STY' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001369s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633070 AND `partno` = 'LFA240F-24-STY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.006844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086147 [ RunTime:0.004495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633041 LIMIT 5 [ RunTime:0.001528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633041 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633041 ORDER BY `unit` DESC [ RunTime:0.018801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633041 LIMIT 2 [ RunTime:0.006149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633041 ORDER BY `minOrder` ASC [ RunTime:0.011827s ]
select * from pdf where partno='LFA240F-24-SR2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.015174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SR2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.007240s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633041 AND `partno` = 'LFA240F-24-SR2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.009432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086132 [ RunTime:0.005063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633040 LIMIT 5 [ RunTime:0.010155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633040 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633040 ORDER BY `unit` DESC [ RunTime:0.008602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633040 LIMIT 2 [ RunTime:0.018994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633040 ORDER BY `minOrder` ASC [ RunTime:0.007336s ]
select * from pdf where partno='LFA240F-24-SR' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.013360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SR' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.004020s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633040 AND `partno` = 'LFA240F-24-SR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.016572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633039 LIMIT 5 [ RunTime:0.008765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633039 ORDER BY `minOrder` ASC [ RunTime:0.008959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633039 ORDER BY `unit` DESC [ RunTime:0.005394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633039 LIMIT 2 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633039 ORDER BY `minOrder` ASC [ RunTime:0.017436s ]
select * from pdf where partno='LFA240F-24-SNGJ1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.005750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNGJ1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000809s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633039 AND `partno` = 'LFA240F-24-SNGJ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.004204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41633038 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633038 ORDER BY `minOrder` ASC [ RunTime:0.007087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41633038 ORDER BY `unit` DESC [ RunTime:0.004913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41633038 LIMIT 2 [ RunTime:0.004096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41633038 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='LFA240F-24-SNG' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.001358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNG' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.007169s ]
SELECT `id` FROM `stock` WHERE `id` <> 41633038 AND `partno` = 'LFA240F-24-SNG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.006517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086131 [ RunTime:0.004957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41632995 LIMIT 5 [ RunTime:0.003523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632995 ORDER BY `minOrder` ASC [ RunTime:0.008558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41632995 ORDER BY `unit` DESC [ RunTime:0.003626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41632995 LIMIT 2 [ RunTime:0.000857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632995 ORDER BY `minOrder` ASC [ RunTime:0.003216s ]
select * from pdf where partno='LFA240F-24-SNJ1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.019901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SNJ1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.012498s ]
SELECT `id` FROM `stock` WHERE `id` <> 41632995 AND `partno` = 'LFA240F-24-SNJ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.008891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130438 [ RunTime:0.006685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41632759 LIMIT 5 [ RunTime:0.010908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632759 ORDER BY `minOrder` ASC [ RunTime:0.007174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41632759 ORDER BY `unit` DESC [ RunTime:0.021531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41632759 LIMIT 2 [ RunTime:0.026908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632759 ORDER BY `minOrder` ASC [ RunTime:0.013342s ]
select * from pdf where partno='LFA240F-24-SY' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.012906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SY' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.015157s ]
SELECT `id` FROM `stock` WHERE `id` <> 41632759 AND `partno` = 'LFA240F-24-SY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.025747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086097 [ RunTime:0.003778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41632749 LIMIT 5 [ RunTime:0.008525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632749 ORDER BY `minOrder` ASC [ RunTime:0.007511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41632749 ORDER BY `unit` DESC [ RunTime:0.014640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41632749 LIMIT 2 [ RunTime:0.003780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632749 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='LFA240F-24-SG' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.007459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SG' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.012106s ]
SELECT `id` FROM `stock` WHERE `id` <> 41632749 AND `partno` = 'LFA240F-24-SG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.022144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130432 [ RunTime:0.001429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41632726 LIMIT 5 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632726 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41632726 ORDER BY `unit` DESC [ RunTime:0.012886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41632726 LIMIT 2 [ RunTime:0.020582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632726 ORDER BY `minOrder` ASC [ RunTime:0.002178s ]
select * from pdf where partno='LFA240F-24-SJ1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.026453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-SJ1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.039743s ]
SELECT `id` FROM `stock` WHERE `id` <> 41632726 AND `partno` = 'LFA240F-24-SJ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.004502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086087 [ RunTime:0.025526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41632725 LIMIT 5 [ RunTime:0.026428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632725 ORDER BY `minOrder` ASC [ RunTime:0.009617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41632725 ORDER BY `unit` DESC [ RunTime:0.055761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41632725 LIMIT 2 [ RunTime:0.092447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41632725 ORDER BY `minOrder` ASC [ RunTime:0.098131s ]
select * from pdf where partno='LFA240F-24-S' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.049077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA240F-24-S' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.035455s ]
SELECT `id` FROM `stock` WHERE `id` <> 41632725 AND `partno` = 'LFA240F-24-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.007951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12086086 [ RunTime:0.047464s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075220s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093884s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053159s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040074s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024962s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043329s ]
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 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032478s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LFA240F-24-S%' OR `brand` LIKE 'LFA240F-24-S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016930s ]