SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.000963s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=9613&search=1' [ RunTime:0.018042s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001265s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.019772s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001248s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.007569s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001922s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011451s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001749s ]
SELECT * FROM `stock_search` WHERE `partno` = '9613' LIMIT 1 [ RunTime:0.054605s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 14:19:00' WHERE `partno` = '9613' [ RunTime:0.039780s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002444s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093603s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385154 LIMIT 5 [ RunTime:0.039588s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385154 ORDER BY `minOrder` ASC [ RunTime:0.015256s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.016609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385154 ORDER BY `unit` DESC [ RunTime:0.070317s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.028198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385154 LIMIT 2 [ RunTime:0.030532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385154 ORDER BY `minOrder` ASC [ RunTime:0.010552s ]
select * from pdf where partno='9613 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.064367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881215 LIMIT 5 [ RunTime:0.050736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881215 ORDER BY `minOrder` ASC [ RunTime:0.089600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881215 ORDER BY `unit` DESC [ RunTime:0.127241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881215 LIMIT 2 [ RunTime:0.076700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881215 ORDER BY `minOrder` ASC [ RunTime:0.056110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13545343 LIMIT 5 [ RunTime:0.081203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13545343 ORDER BY `minOrder` ASC [ RunTime:0.052256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13545343 ORDER BY `unit` DESC [ RunTime:0.025430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13545343 LIMIT 2 [ RunTime:0.049157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13545343 ORDER BY `minOrder` ASC [ RunTime:0.058272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17758133 LIMIT 5 [ RunTime:0.102522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17758133 ORDER BY `minOrder` ASC [ RunTime:0.105390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17758133 ORDER BY `unit` DESC [ RunTime:0.078350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17758133 LIMIT 2 [ RunTime:0.053452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17758133 ORDER BY `minOrder` ASC [ RunTime:0.030631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430771 LIMIT 5 [ RunTime:0.023148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430771 ORDER BY `minOrder` ASC [ RunTime:0.067395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430771 ORDER BY `unit` DESC [ RunTime:0.065832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430771 LIMIT 2 [ RunTime:0.081289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430771 ORDER BY `minOrder` ASC [ RunTime:0.044293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430770 LIMIT 5 [ RunTime:0.082525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430770 ORDER BY `minOrder` ASC [ RunTime:0.068054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430770 ORDER BY `unit` DESC [ RunTime:0.022359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430770 LIMIT 2 [ RunTime:0.042432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430770 ORDER BY `minOrder` ASC [ RunTime:0.038500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430769 LIMIT 5 [ RunTime:0.034089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430769 ORDER BY `minOrder` ASC [ RunTime:0.054675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430769 ORDER BY `unit` DESC [ RunTime:0.130971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430769 LIMIT 2 [ RunTime:0.042924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430769 ORDER BY `minOrder` ASC [ RunTime:0.086954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430768 LIMIT 5 [ RunTime:0.067503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430768 ORDER BY `minOrder` ASC [ RunTime:0.044177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430768 ORDER BY `unit` DESC [ RunTime:0.081303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430768 LIMIT 2 [ RunTime:0.058235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430768 ORDER BY `minOrder` ASC [ RunTime:0.035512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430683 LIMIT 5 [ RunTime:0.059376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430683 ORDER BY `minOrder` ASC [ RunTime:0.067215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430683 ORDER BY `unit` DESC [ RunTime:0.108741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430683 LIMIT 2 [ RunTime:0.004548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430683 ORDER BY `minOrder` ASC [ RunTime:0.027745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430682 LIMIT 5 [ RunTime:0.080776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430682 ORDER BY `minOrder` ASC [ RunTime:0.058310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430682 ORDER BY `unit` DESC [ RunTime:0.018792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430682 LIMIT 2 [ RunTime:0.027864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430682 ORDER BY `minOrder` ASC [ RunTime:0.061976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430681 LIMIT 5 [ RunTime:0.062892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430681 ORDER BY `minOrder` ASC [ RunTime:0.107072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430681 ORDER BY `unit` DESC [ RunTime:0.019103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430681 LIMIT 2 [ RunTime:0.030869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430681 ORDER BY `minOrder` ASC [ RunTime:0.038253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430680 LIMIT 5 [ RunTime:0.065853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430680 ORDER BY `minOrder` ASC [ RunTime:0.014955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430680 ORDER BY `unit` DESC [ RunTime:0.017075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430680 LIMIT 2 [ RunTime:0.029185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430680 ORDER BY `minOrder` ASC [ RunTime:0.004296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430679 LIMIT 5 [ RunTime:0.012052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430679 ORDER BY `minOrder` ASC [ RunTime:0.034105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430679 ORDER BY `unit` DESC [ RunTime:0.046065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430679 LIMIT 2 [ RunTime:0.050822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430679 ORDER BY `minOrder` ASC [ RunTime:0.029439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430587 LIMIT 5 [ RunTime:0.028618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430587 ORDER BY `minOrder` ASC [ RunTime:0.018806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430587 ORDER BY `unit` DESC [ RunTime:0.012599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430587 LIMIT 2 [ RunTime:0.006135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430587 ORDER BY `minOrder` ASC [ RunTime:0.005015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430586 LIMIT 5 [ RunTime:0.014014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430586 ORDER BY `minOrder` ASC [ RunTime:0.024023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430586 ORDER BY `unit` DESC [ RunTime:0.011259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430586 LIMIT 2 [ RunTime:0.014930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430586 ORDER BY `minOrder` ASC [ RunTime:0.029832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430585 LIMIT 5 [ RunTime:0.002348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430585 ORDER BY `minOrder` ASC [ RunTime:0.021776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430585 ORDER BY `unit` DESC [ RunTime:0.025970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430585 LIMIT 2 [ RunTime:0.026533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430585 ORDER BY `minOrder` ASC [ RunTime:0.001888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430584 LIMIT 5 [ RunTime:0.011631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430584 ORDER BY `minOrder` ASC [ RunTime:0.007792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430584 ORDER BY `unit` DESC [ RunTime:0.003678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430584 LIMIT 2 [ RunTime:0.040241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430584 ORDER BY `minOrder` ASC [ RunTime:0.003961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430583 LIMIT 5 [ RunTime:0.020451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430583 ORDER BY `minOrder` ASC [ RunTime:0.043553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430583 ORDER BY `unit` DESC [ RunTime:0.017772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430583 LIMIT 2 [ RunTime:0.057758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430583 ORDER BY `minOrder` ASC [ RunTime:0.001387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430582 LIMIT 5 [ RunTime:0.022950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430582 ORDER BY `minOrder` ASC [ RunTime:0.023603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430582 ORDER BY `unit` DESC [ RunTime:0.017081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430582 LIMIT 2 [ RunTime:0.031095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430582 ORDER BY `minOrder` ASC [ RunTime:0.020547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428027 LIMIT 5 [ RunTime:0.026883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16428027 ORDER BY `minOrder` ASC [ RunTime:0.012618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16428027 ORDER BY `unit` DESC [ RunTime:0.027439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16428027 LIMIT 2 [ RunTime:0.011213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16428027 ORDER BY `minOrder` ASC [ RunTime:0.026675s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020724s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997641 LIMIT 5 [ RunTime:0.014282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997641 ORDER BY `minOrder` ASC [ RunTime:0.011825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997641 ORDER BY `unit` DESC [ RunTime:0.020837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997641 LIMIT 2 [ RunTime:0.020062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997641 ORDER BY `minOrder` ASC [ RunTime:0.017231s ]
select * from pdf where partno='9613 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.008854s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9613 060100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.011551s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997641 AND `partno` = '9613 060100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.008331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385154 [ RunTime:0.057264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913610 LIMIT 5 [ RunTime:0.017983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913610 ORDER BY `minOrder` ASC [ RunTime:0.021105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913610 ORDER BY `unit` DESC [ RunTime:0.028740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913610 LIMIT 2 [ RunTime:0.028319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913610 ORDER BY `minOrder` ASC [ RunTime:0.006490s ]
select * from pdf where partno='9613-1523-002' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.018058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9613-1523-002' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.024471s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913610 AND `partno` = '9613-1523-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.024846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881215 [ RunTime:0.019550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63454722 LIMIT 5 [ RunTime:0.011114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63454722 ORDER BY `minOrder` ASC [ RunTime:0.010561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63454722 ORDER BY `unit` DESC [ RunTime:0.002517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63454722 LIMIT 2 [ RunTime:0.008064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63454722 ORDER BY `minOrder` ASC [ RunTime:0.001450s ]
select * from pdf where partno='9613' and brandshort='Serpac' limit 1 [ RunTime:0.010920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9613' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.017923s ]
SELECT `id` FROM `stock` WHERE `id` <> 63454722 AND `partno` = '9613' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.028028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151629 LIMIT 5 [ RunTime:0.011997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151629 ORDER BY `minOrder` ASC [ RunTime:0.012058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151629 ORDER BY `unit` DESC [ RunTime:0.013706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151629 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151629 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
select * from pdf where partno='96139.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.005260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96139.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004117s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151629 AND `partno` = '96139.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.006482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428027 [ RunTime:0.015074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151628 LIMIT 5 [ RunTime:0.006326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151628 ORDER BY `minOrder` ASC [ RunTime:0.032540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151628 ORDER BY `unit` DESC [ RunTime:0.034885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151628 LIMIT 2 [ RunTime:0.014461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151628 ORDER BY `minOrder` ASC [ RunTime:0.012936s ]
select * from pdf where partno='96138.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.016591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96138.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.009519s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151628 AND `partno` = '96138.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.022622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544109 [ RunTime:0.034940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151627 LIMIT 5 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151627 ORDER BY `minOrder` ASC [ RunTime:0.004516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151627 ORDER BY `unit` DESC [ RunTime:0.015133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151627 LIMIT 2 [ RunTime:0.019546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151627 ORDER BY `minOrder` ASC [ RunTime:0.005563s ]
select * from pdf where partno='96137.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.034937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96137.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.035799s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151627 AND `partno` = '96137.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.027581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544108 [ RunTime:0.020845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151626 LIMIT 5 [ RunTime:0.021832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151626 ORDER BY `minOrder` ASC [ RunTime:0.032519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151626 ORDER BY `unit` DESC [ RunTime:0.071026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151626 LIMIT 2 [ RunTime:0.032007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151626 ORDER BY `minOrder` ASC [ RunTime:0.003822s ]
select * from pdf where partno='96136.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.034629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96136.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.009559s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151626 AND `partno` = '96136.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.043178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428026 [ RunTime:0.041703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151625 LIMIT 5 [ RunTime:0.033628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151625 ORDER BY `minOrder` ASC [ RunTime:0.033333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151625 ORDER BY `unit` DESC [ RunTime:0.005500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151625 LIMIT 2 [ RunTime:0.029982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151625 ORDER BY `minOrder` ASC [ RunTime:0.002521s ]
select * from pdf where partno='96135.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.003049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96135.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.011639s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151625 AND `partno` = '96135.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.009165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428025 [ RunTime:0.045321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151624 LIMIT 5 [ RunTime:0.011083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151624 ORDER BY `minOrder` ASC [ RunTime:0.013148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151624 ORDER BY `unit` DESC [ RunTime:0.004475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151624 LIMIT 2 [ RunTime:0.007257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151624 ORDER BY `minOrder` ASC [ RunTime:0.006957s ]
select * from pdf where partno='96134.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.002190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96134.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.002606s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151624 AND `partno` = '96134.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.045510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544107 [ RunTime:0.020799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151623 LIMIT 5 [ RunTime:0.004275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151623 ORDER BY `minOrder` ASC [ RunTime:0.003940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151623 ORDER BY `unit` DESC [ RunTime:0.016354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151623 LIMIT 2 [ RunTime:0.027458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151623 ORDER BY `minOrder` ASC [ RunTime:0.007600s ]
select * from pdf where partno='96133.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.016762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96133.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.019075s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151623 AND `partno` = '96133.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.029007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544106 [ RunTime:0.015012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151622 LIMIT 5 [ RunTime:0.011450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151622 ORDER BY `minOrder` ASC [ RunTime:0.010361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151622 ORDER BY `unit` DESC [ RunTime:0.042740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151622 LIMIT 2 [ RunTime:0.018020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151622 ORDER BY `minOrder` ASC [ RunTime:0.015762s ]
select * from pdf where partno='96132.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.023456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96132.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.031904s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151622 AND `partno` = '96132.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.021509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544105 [ RunTime:0.005215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151621 LIMIT 5 [ RunTime:0.014670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151621 ORDER BY `minOrder` ASC [ RunTime:0.021586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151621 ORDER BY `unit` DESC [ RunTime:0.012132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151621 LIMIT 2 [ RunTime:0.012552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151621 ORDER BY `minOrder` ASC [ RunTime:0.017143s ]
select * from pdf where partno='96131.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.009631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96131.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.013181s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151621 AND `partno` = '96131.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.015074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428024 [ RunTime:0.000830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63151620 LIMIT 5 [ RunTime:0.011862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151620 ORDER BY `minOrder` ASC [ RunTime:0.009733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63151620 ORDER BY `unit` DESC [ RunTime:0.010377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63151620 LIMIT 2 [ RunTime:0.015947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63151620 ORDER BY `minOrder` ASC [ RunTime:0.010053s ]
select * from pdf where partno='96130.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.005513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96130.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.021338s ]
SELECT `id` FROM `stock` WHERE `id` <> 63151620 AND `partno` = '96130.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.024402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428023 [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63145013 LIMIT 5 [ RunTime:0.004953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145013 ORDER BY `minOrder` ASC [ RunTime:0.039435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63145013 ORDER BY `unit` DESC [ RunTime:0.014232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63145013 LIMIT 2 [ RunTime:0.018958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145013 ORDER BY `minOrder` ASC [ RunTime:0.004110s ]
select * from pdf where partno='96139.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.015636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96139.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.008874s ]
SELECT `id` FROM `stock` WHERE `id` <> 63145013 AND `partno` = '96139.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.007013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430771 [ RunTime:0.005075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63145012 LIMIT 5 [ RunTime:0.006140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145012 ORDER BY `minOrder` ASC [ RunTime:0.007601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63145012 ORDER BY `unit` DESC [ RunTime:0.005140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63145012 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145012 ORDER BY `minOrder` ASC [ RunTime:0.002473s ]
select * from pdf where partno='96138.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.005040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96138.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.001910s ]
SELECT `id` FROM `stock` WHERE `id` <> 63145012 AND `partno` = '96138.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430770 [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63145011 LIMIT 5 [ RunTime:0.008358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145011 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63145011 ORDER BY `unit` DESC [ RunTime:0.013542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63145011 LIMIT 2 [ RunTime:0.008598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145011 ORDER BY `minOrder` ASC [ RunTime:0.006278s ]
select * from pdf where partno='96137.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.002426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96137.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.010597s ]
SELECT `id` FROM `stock` WHERE `id` <> 63145011 AND `partno` = '96137.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.007767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417015 [ RunTime:0.001084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63145010 LIMIT 5 [ RunTime:0.001310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145010 ORDER BY `minOrder` ASC [ RunTime:0.016306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63145010 ORDER BY `unit` DESC [ RunTime:0.000930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63145010 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145010 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='96136.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.002469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96136.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004802s ]
SELECT `id` FROM `stock` WHERE `id` <> 63145010 AND `partno` = '96136.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417014 [ RunTime:0.005730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63145009 LIMIT 5 [ RunTime:0.010197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145009 ORDER BY `minOrder` ASC [ RunTime:0.006042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63145009 ORDER BY `unit` DESC [ RunTime:0.003799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63145009 LIMIT 2 [ RunTime:0.004395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145009 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
select * from pdf where partno='96135.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.000867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96135.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004891s ]
SELECT `id` FROM `stock` WHERE `id` <> 63145009 AND `partno` = '96135.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.002454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417013 [ RunTime:0.005218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63145008 LIMIT 5 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145008 ORDER BY `minOrder` ASC [ RunTime:0.011081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63145008 ORDER BY `unit` DESC [ RunTime:0.004513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63145008 LIMIT 2 [ RunTime:0.008983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145008 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='96134.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.001943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96134.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.001540s ]
SELECT `id` FROM `stock` WHERE `id` <> 63145008 AND `partno` = '96134.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.004380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417012 [ RunTime:0.006567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63145007 LIMIT 5 [ RunTime:0.003424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145007 ORDER BY `minOrder` ASC [ RunTime:0.012019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63145007 ORDER BY `unit` DESC [ RunTime:0.026102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63145007 LIMIT 2 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145007 ORDER BY `minOrder` ASC [ RunTime:0.002677s ]
select * from pdf where partno='96133.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.004328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96133.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.000846s ]
SELECT `id` FROM `stock` WHERE `id` <> 63145007 AND `partno` = '96133.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.002580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417011 [ RunTime:0.000675s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001266s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010648s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001933s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002473s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005112s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002234s ]
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 '9613%' OR `brand` LIKE '9613%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001151s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9613%' OR `brand` LIKE '9613%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014910s ]