SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002448s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=9-103326-0&search=1' [ RunTime:0.004145s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002302s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000722s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002505s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.000610s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003411s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002481s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002964s ]
SELECT * FROM `stock_search` WHERE `partno` = '9-103326-0' LIMIT 1 [ RunTime:0.001685s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 22:14:52' WHERE `partno` = '9-103326-0' [ RunTime:0.001990s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001351s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020893s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486508 LIMIT 5 [ RunTime:0.006534s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486508 ORDER BY `minOrder` ASC [ RunTime:0.007521s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15486508 ORDER BY `unit` DESC [ RunTime:0.005067s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15486508 LIMIT 2 [ RunTime:0.013915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486508 ORDER BY `minOrder` ASC [ RunTime:0.014122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16223822 LIMIT 5 [ RunTime:0.006408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16223822 ORDER BY `minOrder` ASC [ RunTime:0.014849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16223822 ORDER BY `unit` DESC [ RunTime:0.016624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16223822 LIMIT 2 [ RunTime:0.023827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16223822 ORDER BY `minOrder` ASC [ RunTime:0.017765s ]
select * from pdf where partno='9-103326-0-05' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19771992 LIMIT 5 [ RunTime:0.012602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771992 ORDER BY `minOrder` ASC [ RunTime:0.009308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19771992 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19771992 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771992 ORDER BY `minOrder` ASC [ RunTime:0.000995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16224844 LIMIT 5 [ RunTime:0.015731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16224844 ORDER BY `minOrder` ASC [ RunTime:0.005332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16224844 ORDER BY `unit` DESC [ RunTime:0.017803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16224844 LIMIT 2 [ RunTime:0.010904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16224844 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780400 LIMIT 5 [ RunTime:0.009923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780400 ORDER BY `minOrder` ASC [ RunTime:0.011995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12780400 ORDER BY `unit` DESC [ RunTime:0.012539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12780400 LIMIT 2 [ RunTime:0.009618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780400 ORDER BY `minOrder` ASC [ RunTime:0.009714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11600369 LIMIT 5 [ RunTime:0.016944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11600369 ORDER BY `minOrder` ASC [ RunTime:0.018523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11600369 ORDER BY `unit` DESC [ RunTime:0.012914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11600369 LIMIT 2 [ RunTime:0.014085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11600369 ORDER BY `minOrder` ASC [ RunTime:0.021264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786928 LIMIT 5 [ RunTime:0.051781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786928 ORDER BY `minOrder` ASC [ RunTime:0.022004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786928 ORDER BY `unit` DESC [ RunTime:0.002978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786928 LIMIT 2 [ RunTime:0.014959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786928 ORDER BY `minOrder` ASC [ RunTime:0.007633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16214355 LIMIT 5 [ RunTime:0.038405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214355 ORDER BY `minOrder` ASC [ RunTime:0.054740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16214355 ORDER BY `unit` DESC [ RunTime:0.009590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16214355 LIMIT 2 [ RunTime:0.025744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214355 ORDER BY `minOrder` ASC [ RunTime:0.021965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16198923 LIMIT 5 [ RunTime:0.038376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16198923 ORDER BY `minOrder` ASC [ RunTime:0.038288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16198923 ORDER BY `unit` DESC [ RunTime:0.049481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16198923 LIMIT 2 [ RunTime:0.036244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16198923 ORDER BY `minOrder` ASC [ RunTime:0.039777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764191 LIMIT 5 [ RunTime:0.028097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764191 ORDER BY `minOrder` ASC [ RunTime:0.034461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12764191 ORDER BY `unit` DESC [ RunTime:0.025735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12764191 LIMIT 2 [ RunTime:0.047550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764191 ORDER BY `minOrder` ASC [ RunTime:0.011157s ]
select * from pdf where partno='9-103326-0-39' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763991 LIMIT 5 [ RunTime:0.036475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763991 ORDER BY `minOrder` ASC [ RunTime:0.020255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763991 ORDER BY `unit` DESC [ RunTime:0.016138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763991 LIMIT 2 [ RunTime:0.045605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763991 ORDER BY `minOrder` ASC [ RunTime:0.001502s ]
select * from pdf where partno='9-103326-0-38' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.049152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763761 LIMIT 5 [ RunTime:0.019928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763761 ORDER BY `minOrder` ASC [ RunTime:0.006119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763761 ORDER BY `unit` DESC [ RunTime:0.014000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763761 LIMIT 2 [ RunTime:0.024411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763761 ORDER BY `minOrder` ASC [ RunTime:0.008373s ]
select * from pdf where partno='9-103326-0-37' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.027855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763300 LIMIT 5 [ RunTime:0.014353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763300 ORDER BY `minOrder` ASC [ RunTime:0.020246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763300 ORDER BY `unit` DESC [ RunTime:0.007474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763300 LIMIT 2 [ RunTime:0.037719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763300 ORDER BY `minOrder` ASC [ RunTime:0.008027s ]
select * from pdf where partno='9-103326-0-35' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762779 LIMIT 5 [ RunTime:0.003376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762779 ORDER BY `minOrder` ASC [ RunTime:0.002467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762779 ORDER BY `unit` DESC [ RunTime:0.010325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762779 LIMIT 2 [ RunTime:0.012311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762779 ORDER BY `minOrder` ASC [ RunTime:0.003167s ]
select * from pdf where partno='9-103326-0-33' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762170 LIMIT 5 [ RunTime:0.013880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762170 ORDER BY `minOrder` ASC [ RunTime:0.017396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762170 ORDER BY `unit` DESC [ RunTime:0.021503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762170 LIMIT 2 [ RunTime:0.003916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762170 ORDER BY `minOrder` ASC [ RunTime:0.002272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761069 LIMIT 5 [ RunTime:0.001433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761069 ORDER BY `minOrder` ASC [ RunTime:0.006084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12761069 ORDER BY `unit` DESC [ RunTime:0.008420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12761069 LIMIT 2 [ RunTime:0.002124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761069 ORDER BY `minOrder` ASC [ RunTime:0.001962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12760643 LIMIT 5 [ RunTime:0.005902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12760643 ORDER BY `minOrder` ASC [ RunTime:0.015991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12760643 ORDER BY `unit` DESC [ RunTime:0.006126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12760643 LIMIT 2 [ RunTime:0.018762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12760643 ORDER BY `minOrder` ASC [ RunTime:0.001415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12760250 LIMIT 5 [ RunTime:0.011122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12760250 ORDER BY `minOrder` ASC [ RunTime:0.011424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12760250 ORDER BY `unit` DESC [ RunTime:0.008169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12760250 LIMIT 2 [ RunTime:0.036903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12760250 ORDER BY `minOrder` ASC [ RunTime:0.003250s ]
select * from pdf where partno='9-103326-0-26' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12757102 LIMIT 5 [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757102 ORDER BY `minOrder` ASC [ RunTime:0.002356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12757102 ORDER BY `unit` DESC [ RunTime:0.019605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12757102 LIMIT 2 [ RunTime:0.003012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757102 ORDER BY `minOrder` ASC [ RunTime:0.008918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12755573 LIMIT 5 [ RunTime:0.015425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12755573 ORDER BY `minOrder` ASC [ RunTime:0.004276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12755573 ORDER BY `unit` DESC [ RunTime:0.005643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12755573 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12755573 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
select * from pdf where partno='9-103326-0-18' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004663s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001404s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52614890 LIMIT 5 [ RunTime:0.003176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52614890 ORDER BY `minOrder` ASC [ RunTime:0.002915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52614890 ORDER BY `unit` DESC [ RunTime:0.000975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52614890 LIMIT 2 [ RunTime:0.005862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52614890 ORDER BY `minOrder` ASC [ RunTime:0.002629s ]
select * from pdf where partno='9-103326-0-02' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002740s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-02' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000802s ]
SELECT `id` FROM `stock` WHERE `id` <> 52614890 AND `partno` = '9-103326-0-02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486508 [ RunTime:0.010429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52631388 LIMIT 5 [ RunTime:0.004949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52631388 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52631388 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52631388 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52631388 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
select * from pdf where partno='9-103326-0-05' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-05' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004300s ]
SELECT `id` FROM `stock` WHERE `id` <> 52631388 AND `partno` = '9-103326-0-05' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16223822 [ RunTime:0.002653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52640708 LIMIT 5 [ RunTime:0.007546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52640708 ORDER BY `minOrder` ASC [ RunTime:0.010018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52640708 ORDER BY `unit` DESC [ RunTime:0.011892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52640708 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52640708 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='9-103326-0-10' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-10' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007703s ]
SELECT `id` FROM `stock` WHERE `id` <> 52640708 AND `partno` = '9-103326-0-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780400 [ RunTime:0.004632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52627060 LIMIT 5 [ RunTime:0.002611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52627060 ORDER BY `minOrder` ASC [ RunTime:0.014507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52627060 ORDER BY `unit` DESC [ RunTime:0.001967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52627060 LIMIT 2 [ RunTime:0.001618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52627060 ORDER BY `minOrder` ASC [ RunTime:0.009101s ]
select * from pdf where partno='9-103326-0-04' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-04' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004942s ]
SELECT `id` FROM `stock` WHERE `id` <> 52627060 AND `partno` = '9-103326-0-04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786928 [ RunTime:0.016698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52622193 LIMIT 5 [ RunTime:0.002316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52622193 ORDER BY `minOrder` ASC [ RunTime:0.002539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52622193 ORDER BY `unit` DESC [ RunTime:0.001801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52622193 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52622193 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='9-103326-0-03' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-03' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005803s ]
SELECT `id` FROM `stock` WHERE `id` <> 52622193 AND `partno` = '9-103326-0-03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16198923 [ RunTime:0.000546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52634139 LIMIT 5 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52634139 ORDER BY `minOrder` ASC [ RunTime:0.000837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52634139 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52634139 LIMIT 2 [ RunTime:0.007112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52634139 ORDER BY `minOrder` ASC [ RunTime:0.003275s ]
select * from pdf where partno='9-103326-0-06' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-06' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009427s ]
SELECT `id` FROM `stock` WHERE `id` <> 52634139 AND `partno` = '9-103326-0-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52638266 LIMIT 5 [ RunTime:0.005579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52638266 ORDER BY `minOrder` ASC [ RunTime:0.000865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52638266 ORDER BY `unit` DESC [ RunTime:0.007969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52638266 LIMIT 2 [ RunTime:0.002096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52638266 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='9-103326-0-08' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-08' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000642s ]
SELECT `id` FROM `stock` WHERE `id` <> 52638266 AND `partno` = '9-103326-0-08' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11600369 [ RunTime:0.005458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52878649 LIMIT 5 [ RunTime:0.011786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52878649 ORDER BY `minOrder` ASC [ RunTime:0.003405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52878649 ORDER BY `unit` DESC [ RunTime:0.003252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52878649 LIMIT 2 [ RunTime:0.004770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52878649 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
select * from pdf where partno='9-103326-0-39' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-39' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001887s ]
SELECT `id` FROM `stock` WHERE `id` <> 52878649 AND `partno` = '9-103326-0-39' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764191 [ RunTime:0.008288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52878228 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52878228 ORDER BY `minOrder` ASC [ RunTime:0.001379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52878228 ORDER BY `unit` DESC [ RunTime:0.003225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52878228 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52878228 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='9-103326-0-38' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-38' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001856s ]
SELECT `id` FROM `stock` WHERE `id` <> 52878228 AND `partno` = '9-103326-0-38' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763991 [ RunTime:0.005174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52877819 LIMIT 5 [ RunTime:0.025634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52877819 ORDER BY `minOrder` ASC [ RunTime:0.015559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52877819 ORDER BY `unit` DESC [ RunTime:0.020056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52877819 LIMIT 2 [ RunTime:0.005194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52877819 ORDER BY `minOrder` ASC [ RunTime:0.001185s ]
select * from pdf where partno='9-103326-0-37' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-37' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012951s ]
SELECT `id` FROM `stock` WHERE `id` <> 52877819 AND `partno` = '9-103326-0-37' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.030480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763761 [ RunTime:0.006530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52877347 LIMIT 5 [ RunTime:0.015926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52877347 ORDER BY `minOrder` ASC [ RunTime:0.023084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52877347 ORDER BY `unit` DESC [ RunTime:0.010637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52877347 LIMIT 2 [ RunTime:0.007288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52877347 ORDER BY `minOrder` ASC [ RunTime:0.009277s ]
select * from pdf where partno='9-103326-0-36' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-36' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017693s ]
SELECT `id` FROM `stock` WHERE `id` <> 52877347 AND `partno` = '9-103326-0-36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52876917 LIMIT 5 [ RunTime:0.056671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52876917 ORDER BY `minOrder` ASC [ RunTime:0.036349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52876917 ORDER BY `unit` DESC [ RunTime:0.019201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52876917 LIMIT 2 [ RunTime:0.018836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52876917 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
select * from pdf where partno='9-103326-0-35' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-35' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017128s ]
SELECT `id` FROM `stock` WHERE `id` <> 52876917 AND `partno` = '9-103326-0-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.018448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763300 [ RunTime:0.027756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52876404 LIMIT 5 [ RunTime:0.018546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52876404 ORDER BY `minOrder` ASC [ RunTime:0.013884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52876404 ORDER BY `unit` DESC [ RunTime:0.005541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52876404 LIMIT 2 [ RunTime:0.005822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52876404 ORDER BY `minOrder` ASC [ RunTime:0.018674s ]
select * from pdf where partno='9-103326-0-34' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-34' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018331s ]
SELECT `id` FROM `stock` WHERE `id` <> 52876404 AND `partno` = '9-103326-0-34' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.028775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11588785 [ RunTime:0.013579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52875877 LIMIT 5 [ RunTime:0.002337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52875877 ORDER BY `minOrder` ASC [ RunTime:0.023515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52875877 ORDER BY `unit` DESC [ RunTime:0.043934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52875877 LIMIT 2 [ RunTime:0.011782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52875877 ORDER BY `minOrder` ASC [ RunTime:0.007535s ]
select * from pdf where partno='9-103326-0-33' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-33' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003046s ]
SELECT `id` FROM `stock` WHERE `id` <> 52875877 AND `partno` = '9-103326-0-33' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762779 [ RunTime:0.000937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52875321 LIMIT 5 [ RunTime:0.003838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52875321 ORDER BY `minOrder` ASC [ RunTime:0.009996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52875321 ORDER BY `unit` DESC [ RunTime:0.004421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52875321 LIMIT 2 [ RunTime:0.002138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52875321 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='9-103326-0-32' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-32' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000475s ]
SELECT `id` FROM `stock` WHERE `id` <> 52875321 AND `partno` = '9-103326-0-32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11588358 [ RunTime:0.004593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52874665 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52874665 ORDER BY `minOrder` ASC [ RunTime:0.011145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52874665 ORDER BY `unit` DESC [ RunTime:0.002496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52874665 LIMIT 2 [ RunTime:0.003801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52874665 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
select * from pdf where partno='9-103326-0-31' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-31' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008376s ]
SELECT `id` FROM `stock` WHERE `id` <> 52874665 AND `partno` = '9-103326-0-31' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762170 [ RunTime:0.002009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52874027 LIMIT 5 [ RunTime:0.006427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52874027 ORDER BY `minOrder` ASC [ RunTime:0.002410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52874027 ORDER BY `unit` DESC [ RunTime:0.002068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52874027 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52874027 ORDER BY `minOrder` ASC [ RunTime:0.001857s ]
select * from pdf where partno='9-103326-0-30' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-30' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000400s ]
SELECT `id` FROM `stock` WHERE `id` <> 52874027 AND `partno` = '9-103326-0-30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11587814 [ RunTime:0.004594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52873321 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52873321 ORDER BY `minOrder` ASC [ RunTime:0.008007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52873321 ORDER BY `unit` DESC [ RunTime:0.001964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52873321 LIMIT 2 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52873321 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
select * from pdf where partno='9-103326-0-29' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-29' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000392s ]
SELECT `id` FROM `stock` WHERE `id` <> 52873321 AND `partno` = '9-103326-0-29' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52872522 LIMIT 5 [ RunTime:0.001376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52872522 ORDER BY `minOrder` ASC [ RunTime:0.012061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52872522 ORDER BY `unit` DESC [ RunTime:0.006008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52872522 LIMIT 2 [ RunTime:0.011704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52872522 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
select * from pdf where partno='9-103326-0-28' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-28' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000879s ]
SELECT `id` FROM `stock` WHERE `id` <> 52872522 AND `partno` = '9-103326-0-28' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761069 [ RunTime:0.004978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52871698 LIMIT 5 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52871698 ORDER BY `minOrder` ASC [ RunTime:0.015103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52871698 ORDER BY `unit` DESC [ RunTime:0.002224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52871698 LIMIT 2 [ RunTime:0.012486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52871698 ORDER BY `minOrder` ASC [ RunTime:0.009488s ]
select * from pdf where partno='9-103326-0-27' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-103326-0-27' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004789s ]
SELECT `id` FROM `stock` WHERE `id` <> 52871698 AND `partno` = '9-103326-0-27' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12760643 [ RunTime:0.005105s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022073s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005511s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001594s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007654s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010924s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009331s ]
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 '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001519s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9-103326-0%' OR `brand` LIKE '9-103326-0%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010019s ]