SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002260s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=6656&search=1' [ RunTime:0.024249s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002807s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.027346s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001502s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.045765s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003595s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003857s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001664s ]
SELECT * FROM `stock_search` WHERE `partno` = '6656' LIMIT 1 [ RunTime:0.043789s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-22 15:14:41' WHERE `partno` = '6656' [ RunTime:0.048281s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004277s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.108875s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440716 LIMIT 5 [ RunTime:0.114011s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.025343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440716 ORDER BY `minOrder` ASC [ RunTime:0.032825s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440716 ORDER BY `unit` DESC [ RunTime:0.036150s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440716 LIMIT 2 [ RunTime:0.041003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440716 ORDER BY `minOrder` ASC [ RunTime:0.056163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579854 LIMIT 5 [ RunTime:0.065903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579854 ORDER BY `minOrder` ASC [ RunTime:0.105500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579854 ORDER BY `unit` DESC [ RunTime:0.072989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579854 LIMIT 2 [ RunTime:0.024928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579854 ORDER BY `minOrder` ASC [ RunTime:0.018347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298134 LIMIT 5 [ RunTime:0.053188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298134 ORDER BY `minOrder` ASC [ RunTime:0.026050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298134 ORDER BY `unit` DESC [ RunTime:0.067885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298134 LIMIT 2 [ RunTime:0.030559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298134 ORDER BY `minOrder` ASC [ RunTime:0.020504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440728 LIMIT 5 [ RunTime:0.012180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440728 ORDER BY `minOrder` ASC [ RunTime:0.065372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440728 ORDER BY `unit` DESC [ RunTime:0.034441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440728 LIMIT 2 [ RunTime:0.053919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440728 ORDER BY `minOrder` ASC [ RunTime:0.052414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298228 LIMIT 5 [ RunTime:0.081452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298228 ORDER BY `minOrder` ASC [ RunTime:0.013814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298228 ORDER BY `unit` DESC [ RunTime:0.058665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298228 LIMIT 2 [ RunTime:0.055857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298228 ORDER BY `minOrder` ASC [ RunTime:0.007428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579271 LIMIT 5 [ RunTime:0.057575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579271 ORDER BY `minOrder` ASC [ RunTime:0.088471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579271 ORDER BY `unit` DESC [ RunTime:0.102356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579271 LIMIT 2 [ RunTime:0.063661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579271 ORDER BY `minOrder` ASC [ RunTime:0.024050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577772 LIMIT 5 [ RunTime:0.029911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577772 ORDER BY `minOrder` ASC [ RunTime:0.026456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577772 ORDER BY `unit` DESC [ RunTime:0.021303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577772 LIMIT 2 [ RunTime:0.049829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577772 ORDER BY `minOrder` ASC [ RunTime:0.002562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579882 LIMIT 5 [ RunTime:0.098504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579882 ORDER BY `minOrder` ASC [ RunTime:0.004748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579882 ORDER BY `unit` DESC [ RunTime:0.028043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579882 LIMIT 2 [ RunTime:0.098710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579882 ORDER BY `minOrder` ASC [ RunTime:0.011373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577780 LIMIT 5 [ RunTime:0.029347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577780 ORDER BY `minOrder` ASC [ RunTime:0.010150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577780 ORDER BY `unit` DESC [ RunTime:0.035917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577780 LIMIT 2 [ RunTime:0.004088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577780 ORDER BY `minOrder` ASC [ RunTime:0.059005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579273 LIMIT 5 [ RunTime:0.052506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579273 ORDER BY `minOrder` ASC [ RunTime:0.040119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579273 ORDER BY `unit` DESC [ RunTime:0.079045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579273 LIMIT 2 [ RunTime:0.186771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579273 ORDER BY `minOrder` ASC [ RunTime:0.040428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577790 LIMIT 5 [ RunTime:0.019489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577790 ORDER BY `minOrder` ASC [ RunTime:0.043295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577790 ORDER BY `unit` DESC [ RunTime:0.036568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577790 LIMIT 2 [ RunTime:0.041734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577790 ORDER BY `minOrder` ASC [ RunTime:0.013829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577784 LIMIT 5 [ RunTime:0.013538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577784 ORDER BY `minOrder` ASC [ RunTime:0.131750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577784 ORDER BY `unit` DESC [ RunTime:0.070683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577784 LIMIT 2 [ RunTime:0.083247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577784 ORDER BY `minOrder` ASC [ RunTime:0.018077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578511 LIMIT 5 [ RunTime:0.040854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578511 ORDER BY `minOrder` ASC [ RunTime:0.016552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578511 ORDER BY `unit` DESC [ RunTime:0.066414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578511 LIMIT 2 [ RunTime:0.059054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578511 ORDER BY `minOrder` ASC [ RunTime:0.034530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440281 LIMIT 5 [ RunTime:0.067742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440281 ORDER BY `minOrder` ASC [ RunTime:0.053945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440281 ORDER BY `unit` DESC [ RunTime:0.049734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440281 LIMIT 2 [ RunTime:0.025247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440281 ORDER BY `minOrder` ASC [ RunTime:0.030991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577819 LIMIT 5 [ RunTime:0.062671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577819 ORDER BY `minOrder` ASC [ RunTime:0.018190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577819 ORDER BY `unit` DESC [ RunTime:0.031420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577819 LIMIT 2 [ RunTime:0.018162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577819 ORDER BY `minOrder` ASC [ RunTime:0.020151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579920 LIMIT 5 [ RunTime:0.046680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579920 ORDER BY `minOrder` ASC [ RunTime:0.057791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579920 ORDER BY `unit` DESC [ RunTime:0.033170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579920 LIMIT 2 [ RunTime:0.020782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579920 ORDER BY `minOrder` ASC [ RunTime:0.025079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13630 LIMIT 5 [ RunTime:0.034056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13630 ORDER BY `minOrder` ASC [ RunTime:0.049135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13630 ORDER BY `unit` DESC [ RunTime:0.061815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13630 LIMIT 2 [ RunTime:0.051323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13630 ORDER BY `minOrder` ASC [ RunTime:0.006174s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66569-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.039290s ]
SELECT `id` FROM `stock` WHERE `id` <> 13630 AND `partno` = '66569-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.018121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12800850 LIMIT 5 [ RunTime:0.011523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12800850 ORDER BY `minOrder` ASC [ RunTime:0.016618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12800850 ORDER BY `unit` DESC [ RunTime:0.015910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12800850 LIMIT 2 [ RunTime:0.017345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12800850 ORDER BY `minOrder` ASC [ RunTime:0.006515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440311 LIMIT 5 [ RunTime:0.010236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440311 ORDER BY `minOrder` ASC [ RunTime:0.019797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440311 ORDER BY `unit` DESC [ RunTime:0.024146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440311 LIMIT 2 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440311 ORDER BY `minOrder` ASC [ RunTime:0.018970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 676 LIMIT 5 [ RunTime:0.003350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 676 ORDER BY `minOrder` ASC [ RunTime:0.039184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 676 ORDER BY `unit` DESC [ RunTime:0.009184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 676 LIMIT 2 [ RunTime:0.006442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 676 ORDER BY `minOrder` ASC [ RunTime:0.019517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66565-7.' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.010956s ]
SELECT `id` FROM `stock` WHERE `id` <> 676 AND `partno` = '66565-7.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.012665s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32272620 LIMIT 5 [ RunTime:0.011197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272620 ORDER BY `minOrder` ASC [ RunTime:0.036991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32272620 ORDER BY `unit` DESC [ RunTime:0.004239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32272620 LIMIT 2 [ RunTime:0.015734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272620 ORDER BY `minOrder` ASC [ RunTime:0.008629s ]
select * from pdf where partno='66563-8' and brandshort='te connectivity' limit 1 [ RunTime:0.014261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66563-8' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.030686s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354391 LIMIT 5 [ RunTime:0.027928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354391 ORDER BY `minOrder` ASC [ RunTime:0.024769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354391 ORDER BY `unit` DESC [ RunTime:0.005476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354391 LIMIT 2 [ RunTime:0.011314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354391 ORDER BY `minOrder` ASC [ RunTime:0.023862s ]
select * from pdf where partno='66569-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66569-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011281s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354391 AND `partno` = '66569-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.035412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577772 [ RunTime:0.022654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354922 LIMIT 5 [ RunTime:0.035185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354922 ORDER BY `minOrder` ASC [ RunTime:0.013599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354922 ORDER BY `unit` DESC [ RunTime:0.022794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354922 LIMIT 2 [ RunTime:0.045770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354922 ORDER BY `minOrder` ASC [ RunTime:0.030768s ]
select * from pdf where partno='66563-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66563-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024423s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354922 AND `partno` = '66563-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298134 [ RunTime:0.018468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354778 LIMIT 5 [ RunTime:0.030169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354778 ORDER BY `minOrder` ASC [ RunTime:0.051318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354778 ORDER BY `unit` DESC [ RunTime:0.015006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354778 LIMIT 2 [ RunTime:0.006838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354778 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
select * from pdf where partno='66566-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66566-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027839s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354778 AND `partno` = '66566-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298228 [ RunTime:0.019708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354184 LIMIT 5 [ RunTime:0.014148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354184 ORDER BY `minOrder` ASC [ RunTime:0.014269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354184 ORDER BY `unit` DESC [ RunTime:0.029085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354184 LIMIT 2 [ RunTime:0.011404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354184 ORDER BY `minOrder` ASC [ RunTime:0.012624s ]
select * from pdf where partno='66563-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66563-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019173s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354184 AND `partno` = '66563-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.037277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579273 [ RunTime:0.079860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354139 LIMIT 5 [ RunTime:0.020339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354139 ORDER BY `minOrder` ASC [ RunTime:0.011461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354139 ORDER BY `unit` DESC [ RunTime:0.022329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354139 LIMIT 2 [ RunTime:0.040692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354139 ORDER BY `minOrder` ASC [ RunTime:0.016067s ]
select * from pdf where partno='66564-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.047695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66564-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.059688s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354139 AND `partno` = '66564-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578511 [ RunTime:0.036945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354757 LIMIT 5 [ RunTime:0.034922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354757 ORDER BY `minOrder` ASC [ RunTime:0.036302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354757 ORDER BY `unit` DESC [ RunTime:0.004853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354757 LIMIT 2 [ RunTime:0.012957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354757 ORDER BY `minOrder` ASC [ RunTime:0.023414s ]
select * from pdf where partno='66563-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66563-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.022677s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354757 AND `partno` = '66563-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577780 [ RunTime:0.003935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60355085 LIMIT 5 [ RunTime:0.041137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355085 ORDER BY `minOrder` ASC [ RunTime:0.037901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60355085 ORDER BY `unit` DESC [ RunTime:0.016256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60355085 LIMIT 2 [ RunTime:0.046693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355085 ORDER BY `minOrder` ASC [ RunTime:0.018913s ]
select * from pdf where partno='66564-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.048984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66564-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033129s ]
SELECT `id` FROM `stock` WHERE `id` <> 60355085 AND `partno` = '66564-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577784 [ RunTime:0.037620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354886 LIMIT 5 [ RunTime:0.015172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354886 ORDER BY `minOrder` ASC [ RunTime:0.034395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354886 ORDER BY `unit` DESC [ RunTime:0.032639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354886 LIMIT 2 [ RunTime:0.041695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354886 ORDER BY `minOrder` ASC [ RunTime:0.009011s ]
select * from pdf where partno='66564-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.029005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66564-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.031734s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354886 AND `partno` = '66564-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.034170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577790 [ RunTime:0.026012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354182 LIMIT 5 [ RunTime:0.023923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354182 ORDER BY `minOrder` ASC [ RunTime:0.030548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354182 ORDER BY `unit` DESC [ RunTime:0.017912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354182 LIMIT 2 [ RunTime:0.017867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354182 ORDER BY `minOrder` ASC [ RunTime:0.015581s ]
select * from pdf where partno='66566-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66566-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027459s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354182 AND `partno` = '66566-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579271 [ RunTime:0.028139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354925 LIMIT 5 [ RunTime:0.057749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354925 ORDER BY `minOrder` ASC [ RunTime:0.007954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354925 ORDER BY `unit` DESC [ RunTime:0.018014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354925 LIMIT 2 [ RunTime:0.026408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354925 ORDER BY `minOrder` ASC [ RunTime:0.019926s ]
select * from pdf where partno='66563-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66563-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.028816s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354925 AND `partno` = '66563-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440281 [ RunTime:0.017626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354416 LIMIT 5 [ RunTime:0.013633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354416 ORDER BY `minOrder` ASC [ RunTime:0.012248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354416 ORDER BY `unit` DESC [ RunTime:0.023815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354416 LIMIT 2 [ RunTime:0.002330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354416 ORDER BY `minOrder` ASC [ RunTime:0.001526s ]
select * from pdf where partno='66566-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66566-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013344s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354416 AND `partno` = '66566-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.044400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440728 [ RunTime:0.003454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354202 LIMIT 5 [ RunTime:0.008478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354202 ORDER BY `minOrder` ASC [ RunTime:0.009074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354202 ORDER BY `unit` DESC [ RunTime:0.012145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354202 LIMIT 2 [ RunTime:0.022078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354202 ORDER BY `minOrder` ASC [ RunTime:0.007756s ]
select * from pdf where partno='66565-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.029532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66565-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011807s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354202 AND `partno` = '66565-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579882 [ RunTime:0.014170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60355152 LIMIT 5 [ RunTime:0.033574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355152 ORDER BY `minOrder` ASC [ RunTime:0.023767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60355152 ORDER BY `unit` DESC [ RunTime:0.007821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60355152 LIMIT 2 [ RunTime:0.015044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355152 ORDER BY `minOrder` ASC [ RunTime:0.026468s ]
select * from pdf where partno='66563-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66563-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033342s ]
SELECT `id` FROM `stock` WHERE `id` <> 60355152 AND `partno` = '66563-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.024337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577819 [ RunTime:0.031636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354166 LIMIT 5 [ RunTime:0.006695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354166 ORDER BY `minOrder` ASC [ RunTime:0.026039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354166 ORDER BY `unit` DESC [ RunTime:0.011302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354166 LIMIT 2 [ RunTime:0.004999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354166 ORDER BY `minOrder` ASC [ RunTime:0.001955s ]
select * from pdf where partno='66565-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66565-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033357s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354166 AND `partno` = '66565-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579854 [ RunTime:0.012674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53538019 LIMIT 5 [ RunTime:0.011498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538019 ORDER BY `minOrder` ASC [ RunTime:0.013423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53538019 ORDER BY `unit` DESC [ RunTime:0.001737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53538019 LIMIT 2 [ RunTime:0.001416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538019 ORDER BY `minOrder` ASC [ RunTime:0.006691s ]
select * from pdf where partno='66566-7' and brandshort='TE Connectivity' limit 1 [ RunTime:0.026253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66566-7' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.044286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60355412 LIMIT 5 [ RunTime:0.011188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355412 ORDER BY `minOrder` ASC [ RunTime:0.040341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60355412 ORDER BY `unit` DESC [ RunTime:0.014937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60355412 LIMIT 2 [ RunTime:0.003753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355412 ORDER BY `minOrder` ASC [ RunTime:0.003863s ]
select * from pdf where partno='66565-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66565-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019957s ]
SELECT `id` FROM `stock` WHERE `id` <> 60355412 AND `partno` = '66565-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.055139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440311 [ RunTime:0.005531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64511601 LIMIT 5 [ RunTime:0.026738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64511601 ORDER BY `minOrder` ASC [ RunTime:0.026001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64511601 ORDER BY `unit` DESC [ RunTime:0.039872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64511601 LIMIT 2 [ RunTime:0.010960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64511601 ORDER BY `minOrder` ASC [ RunTime:0.003656s ]
select * from pdf where partno='6656B-1HV' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6656B-1HV' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.014290s ]
SELECT `id` FROM `stock` WHERE `id` <> 64511601 AND `partno` = '6656B-1HV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.018397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64509245 LIMIT 5 [ RunTime:0.025979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64509245 ORDER BY `minOrder` ASC [ RunTime:0.014816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64509245 ORDER BY `unit` DESC [ RunTime:0.023777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64509245 LIMIT 2 [ RunTime:0.015479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64509245 ORDER BY `minOrder` ASC [ RunTime:0.018515s ]
select * from pdf where partno='6656B-1' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6656B-1' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006616s ]
SELECT `id` FROM `stock` WHERE `id` <> 64509245 AND `partno` = '6656B-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63433879 LIMIT 5 [ RunTime:0.001029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433879 ORDER BY `minOrder` ASC [ RunTime:0.010302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63433879 ORDER BY `unit` DESC [ RunTime:0.003876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63433879 LIMIT 2 [ RunTime:0.013719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433879 ORDER BY `minOrder` ASC [ RunTime:0.001605s ]
select * from pdf where partno='6656CB' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.000667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6656CB' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.008083s ]
SELECT `id` FROM `stock` WHERE `id` <> 63433879 AND `partno` = '6656CB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.001760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037941 [ RunTime:0.006828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63432588 LIMIT 5 [ RunTime:0.012297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63432588 ORDER BY `minOrder` ASC [ RunTime:0.005722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63432588 ORDER BY `unit` DESC [ RunTime:0.006828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63432588 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63432588 ORDER BY `minOrder` ASC [ RunTime:0.008027s ]
select * from pdf where partno='6656VA' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.003798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6656VA' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.007692s ]
SELECT `id` FROM `stock` WHERE `id` <> 63432588 AND `partno` = '6656VA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.003348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037376 [ RunTime:0.001826s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017088s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016947s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007656s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014095s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016778s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019542s ]
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 '6656%' OR `brand` LIKE '6656%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023000s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6656%' OR `brand` LIKE '6656%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022090s ]