SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002904s ]
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=796&search=1' [ RunTime:0.004171s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002375s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008591s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001707s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.007542s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001286s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004542s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001393s ]
SELECT * FROM `stock_search` WHERE `partno` = '796' LIMIT 1 [ RunTime:0.009844s ]
UPDATE `stock_search` SET `count` = 35 , `updatetime` = '2026-08-24 01:28:04' WHERE `partno` = '796' [ RunTime:0.012450s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001008s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.095582s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649389 LIMIT 5 [ RunTime:0.033354s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649389 ORDER BY `minOrder` ASC [ RunTime:0.038180s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649389 ORDER BY `unit` DESC [ RunTime:0.028664s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649389 LIMIT 2 [ RunTime:0.031703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649389 ORDER BY `minOrder` ASC [ RunTime:0.013181s ]
select * from pdf where partno='796638-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451534 LIMIT 5 [ RunTime:0.033157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451534 ORDER BY `minOrder` ASC [ RunTime:0.032072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15451534 ORDER BY `unit` DESC [ RunTime:0.061009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15451534 LIMIT 2 [ RunTime:0.035759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451534 ORDER BY `minOrder` ASC [ RunTime:0.014017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649410 LIMIT 5 [ RunTime:0.040976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649410 ORDER BY `minOrder` ASC [ RunTime:0.046135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649410 ORDER BY `unit` DESC [ RunTime:0.040479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649410 LIMIT 2 [ RunTime:0.052756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649410 ORDER BY `minOrder` ASC [ RunTime:0.023972s ]
select * from pdf where partno='796636-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657398 LIMIT 5 [ RunTime:0.062202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657398 ORDER BY `minOrder` ASC [ RunTime:0.025659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19657398 ORDER BY `unit` DESC [ RunTime:0.080599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19657398 LIMIT 2 [ RunTime:0.013051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657398 ORDER BY `minOrder` ASC [ RunTime:0.023261s ]
select * from pdf where partno='796644-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605236 LIMIT 5 [ RunTime:0.031131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605236 ORDER BY `minOrder` ASC [ RunTime:0.031132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605236 ORDER BY `unit` DESC [ RunTime:0.049520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605236 LIMIT 2 [ RunTime:0.023755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605236 ORDER BY `minOrder` ASC [ RunTime:0.027954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605748 LIMIT 5 [ RunTime:0.048176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605748 ORDER BY `minOrder` ASC [ RunTime:0.062036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605748 ORDER BY `unit` DESC [ RunTime:0.071505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605748 LIMIT 2 [ RunTime:0.039683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605748 ORDER BY `minOrder` ASC [ RunTime:0.014914s ]
select * from pdf where partno='796644-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11689143 LIMIT 5 [ RunTime:0.026259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11689143 ORDER BY `minOrder` ASC [ RunTime:0.036110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11689143 ORDER BY `unit` DESC [ RunTime:0.023323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11689143 LIMIT 2 [ RunTime:0.030919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11689143 ORDER BY `minOrder` ASC [ RunTime:0.002512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615222 LIMIT 5 [ RunTime:0.032133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615222 ORDER BY `minOrder` ASC [ RunTime:0.034741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19615222 ORDER BY `unit` DESC [ RunTime:0.002395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19615222 LIMIT 2 [ RunTime:0.012472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615222 ORDER BY `minOrder` ASC [ RunTime:0.011888s ]
select * from pdf where partno='796636-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19607865 LIMIT 5 [ RunTime:0.029255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19607865 ORDER BY `minOrder` ASC [ RunTime:0.028525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19607865 ORDER BY `unit` DESC [ RunTime:0.017534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19607865 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19607865 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19610339 LIMIT 5 [ RunTime:0.009309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19610339 ORDER BY `minOrder` ASC [ RunTime:0.007558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19610339 ORDER BY `unit` DESC [ RunTime:0.010236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19610339 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19610339 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11443533 LIMIT 5 [ RunTime:0.000973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11443533 ORDER BY `minOrder` ASC [ RunTime:0.002944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11443533 ORDER BY `unit` DESC [ RunTime:0.001819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11443533 LIMIT 2 [ RunTime:0.007753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11443533 ORDER BY `minOrder` ASC [ RunTime:0.001672s ]
select * from pdf where partno='796690-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606591 LIMIT 5 [ RunTime:0.006782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606591 ORDER BY `minOrder` ASC [ RunTime:0.001522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606591 ORDER BY `unit` DESC [ RunTime:0.016750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606591 LIMIT 2 [ RunTime:0.003734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606591 ORDER BY `minOrder` ASC [ RunTime:0.004081s ]
select * from pdf where partno='796636-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615174 LIMIT 5 [ RunTime:0.025430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615174 ORDER BY `minOrder` ASC [ RunTime:0.016005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19615174 ORDER BY `unit` DESC [ RunTime:0.007057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19615174 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615174 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='796644-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12558906 LIMIT 5 [ RunTime:0.003565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12558906 ORDER BY `minOrder` ASC [ RunTime:0.000827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12558906 ORDER BY `unit` DESC [ RunTime:0.006361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12558906 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12558906 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
select * from pdf where partno='796740-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19610401 LIMIT 5 [ RunTime:0.002486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19610401 ORDER BY `minOrder` ASC [ RunTime:0.018830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19610401 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19610401 LIMIT 2 [ RunTime:0.001394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19610401 ORDER BY `minOrder` ASC [ RunTime:0.001521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13497646 LIMIT 5 [ RunTime:0.002765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13497646 ORDER BY `minOrder` ASC [ RunTime:0.002214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13497646 ORDER BY `unit` DESC [ RunTime:0.001060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13497646 LIMIT 2 [ RunTime:0.010558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13497646 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='7960A 1SW1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.008291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544258 LIMIT 5 [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544258 ORDER BY `minOrder` ASC [ RunTime:0.002306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544258 ORDER BY `unit` DESC [ RunTime:0.000852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544258 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544258 ORDER BY `minOrder` ASC [ RunTime:0.003910s ]
select * from pdf where partno='796689-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657378 LIMIT 5 [ RunTime:0.016631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657378 ORDER BY `minOrder` ASC [ RunTime:0.025560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19657378 ORDER BY `unit` DESC [ RunTime:0.001942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19657378 LIMIT 2 [ RunTime:0.022898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657378 ORDER BY `minOrder` ASC [ RunTime:0.011236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435566 LIMIT 5 [ RunTime:0.002036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435566 ORDER BY `minOrder` ASC [ RunTime:0.005978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11435566 ORDER BY `unit` DESC [ RunTime:0.000550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11435566 LIMIT 2 [ RunTime:0.021597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435566 ORDER BY `minOrder` ASC [ RunTime:0.021272s ]
select * from pdf where partno='796692-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17302140 LIMIT 5 [ RunTime:0.031401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17302140 ORDER BY `minOrder` ASC [ RunTime:0.015937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17302140 ORDER BY `unit` DESC [ RunTime:0.009877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17302140 LIMIT 2 [ RunTime:0.008749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17302140 ORDER BY `minOrder` ASC [ RunTime:0.013067s ]
select * from pdf where partno='796636-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012350s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275555 LIMIT 5 [ RunTime:0.007341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275555 ORDER BY `minOrder` ASC [ RunTime:0.009819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275555 ORDER BY `unit` DESC [ RunTime:0.002218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275555 LIMIT 2 [ RunTime:0.004915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275555 ORDER BY `minOrder` ASC [ RunTime:0.001213s ]
select * from pdf where partno='796636-2' and brandshort='te connectivity' limit 1 [ RunTime:0.011089s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796636-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.003359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275218 LIMIT 5 [ RunTime:0.016335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275218 ORDER BY `minOrder` ASC [ RunTime:0.001676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275218 ORDER BY `unit` DESC [ RunTime:0.010551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275218 LIMIT 2 [ RunTime:0.001246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275218 ORDER BY `minOrder` ASC [ RunTime:0.001295s ]
select * from pdf where partno='796638-2' and brandshort='te connectivity' limit 1 [ RunTime:0.006675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796638-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.002324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275151 LIMIT 5 [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275151 ORDER BY `minOrder` ASC [ RunTime:0.002185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275151 ORDER BY `unit` DESC [ RunTime:0.002103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275151 LIMIT 2 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275151 ORDER BY `minOrder` ASC [ RunTime:0.007664s ]
select * from pdf where partno='796644-2' and brandshort='te connectivity' limit 1 [ RunTime:0.004256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796644-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.016393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275036 LIMIT 5 [ RunTime:0.019470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275036 ORDER BY `minOrder` ASC [ RunTime:0.046027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275036 ORDER BY `unit` DESC [ RunTime:0.013785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275036 LIMIT 2 [ RunTime:0.008438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275036 ORDER BY `minOrder` ASC [ RunTime:0.018429s ]
select * from pdf where partno='796634-2' and brandshort='te connectivity' limit 1 [ RunTime:0.026536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796634-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.033448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275351 LIMIT 5 [ RunTime:0.036812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275351 ORDER BY `minOrder` ASC [ RunTime:0.065979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275351 ORDER BY `unit` DESC [ RunTime:0.049673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275351 LIMIT 2 [ RunTime:0.023309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275351 ORDER BY `minOrder` ASC [ RunTime:0.028739s ]
select * from pdf where partno='796949-2' and brandshort='te connectivity' limit 1 [ RunTime:0.032940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796949-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.023126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275148 LIMIT 5 [ RunTime:0.026993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275148 ORDER BY `minOrder` ASC [ RunTime:0.015680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275148 ORDER BY `unit` DESC [ RunTime:0.005131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275148 LIMIT 2 [ RunTime:0.025316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275148 ORDER BY `minOrder` ASC [ RunTime:0.019544s ]
select * from pdf where partno='796636-3' and brandshort='te connectivity' limit 1 [ RunTime:0.007879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796636-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.044316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275152 LIMIT 5 [ RunTime:0.021853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275152 ORDER BY `minOrder` ASC [ RunTime:0.018722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275152 ORDER BY `unit` DESC [ RunTime:0.024721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275152 LIMIT 2 [ RunTime:0.012241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275152 ORDER BY `minOrder` ASC [ RunTime:0.013202s ]
select * from pdf where partno='796644-3' and brandshort='te connectivity' limit 1 [ RunTime:0.002215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796644-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275348 LIMIT 5 [ RunTime:0.020122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275348 ORDER BY `minOrder` ASC [ RunTime:0.007500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275348 ORDER BY `unit` DESC [ RunTime:0.002059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275348 LIMIT 2 [ RunTime:0.002284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275348 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='796642-3' and brandshort='te connectivity' limit 1 [ RunTime:0.000998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796642-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.019380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275149 LIMIT 5 [ RunTime:0.012796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275149 ORDER BY `minOrder` ASC [ RunTime:0.010727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275149 ORDER BY `unit` DESC [ RunTime:0.005432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275149 LIMIT 2 [ RunTime:0.029318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275149 ORDER BY `minOrder` ASC [ RunTime:0.008806s ]
select * from pdf where partno='796639-3' and brandshort='te connectivity' limit 1 [ RunTime:0.031406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796639-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.021154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275474 LIMIT 5 [ RunTime:0.014207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275474 ORDER BY `minOrder` ASC [ RunTime:0.012097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275474 ORDER BY `unit` DESC [ RunTime:0.002456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275474 LIMIT 2 [ RunTime:0.008831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275474 ORDER BY `minOrder` ASC [ RunTime:0.014665s ]
select * from pdf where partno='796644-4' and brandshort='te connectivity' limit 1 [ RunTime:0.006018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796644-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.025538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275472 LIMIT 5 [ RunTime:0.010283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275472 ORDER BY `minOrder` ASC [ RunTime:0.014468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275472 ORDER BY `unit` DESC [ RunTime:0.014645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275472 LIMIT 2 [ RunTime:0.003803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275472 ORDER BY `minOrder` ASC [ RunTime:0.019838s ]
select * from pdf where partno='796638-6' and brandshort='te connectivity' limit 1 [ RunTime:0.007981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796638-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.058803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275349 LIMIT 5 [ RunTime:0.017659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275349 ORDER BY `minOrder` ASC [ RunTime:0.000833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275349 ORDER BY `unit` DESC [ RunTime:0.008328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275349 LIMIT 2 [ RunTime:0.009000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275349 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='796682-3' and brandshort='te connectivity' limit 1 [ RunTime:0.001065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796682-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.033924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275153 LIMIT 5 [ RunTime:0.003510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275153 ORDER BY `minOrder` ASC [ RunTime:0.005935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275153 ORDER BY `unit` DESC [ RunTime:0.003072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275153 LIMIT 2 [ RunTime:0.021020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275153 ORDER BY `minOrder` ASC [ RunTime:0.008331s ]
select * from pdf where partno='796692-2' and brandshort='te connectivity' limit 1 [ RunTime:0.007624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796692-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32272404 LIMIT 5 [ RunTime:0.026824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272404 ORDER BY `minOrder` ASC [ RunTime:0.005395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32272404 ORDER BY `unit` DESC [ RunTime:0.013837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32272404 LIMIT 2 [ RunTime:0.015622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272404 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
select * from pdf where partno='796271-1' and brandshort='te connectivity' limit 1 [ RunTime:0.015086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796271-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.050541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275475 LIMIT 5 [ RunTime:0.003628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275475 ORDER BY `minOrder` ASC [ RunTime:0.006327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275475 ORDER BY `unit` DESC [ RunTime:0.009362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275475 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275475 ORDER BY `minOrder` ASC [ RunTime:0.005631s ]
select * from pdf where partno='796690-4' and brandshort='te connectivity' limit 1 [ RunTime:0.022100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796690-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.053033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275347 LIMIT 5 [ RunTime:0.029838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275347 ORDER BY `minOrder` ASC [ RunTime:0.019923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275347 ORDER BY `unit` DESC [ RunTime:0.022706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275347 LIMIT 2 [ RunTime:0.024848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275347 ORDER BY `minOrder` ASC [ RunTime:0.001707s ]
select * from pdf where partno='796640-4' and brandshort='te connectivity' limit 1 [ RunTime:0.023998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796640-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.038130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275392 LIMIT 5 [ RunTime:0.018790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275392 ORDER BY `minOrder` ASC [ RunTime:0.043032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275392 ORDER BY `unit` DESC [ RunTime:0.031165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275392 LIMIT 2 [ RunTime:0.001226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275392 ORDER BY `minOrder` ASC [ RunTime:0.004389s ]
select * from pdf where partno='796858-4' and brandshort='te connectivity' limit 1 [ RunTime:0.037228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796858-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.036823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275471 LIMIT 5 [ RunTime:0.016562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275471 ORDER BY `minOrder` ASC [ RunTime:0.043370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275471 ORDER BY `unit` DESC [ RunTime:0.044878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275471 LIMIT 2 [ RunTime:0.008488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275471 ORDER BY `minOrder` ASC [ RunTime:0.027782s ]
select * from pdf where partno='796635-4' and brandshort='te connectivity' limit 1 [ RunTime:0.037099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796635-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.035797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275154 LIMIT 5 [ RunTime:0.035980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275154 ORDER BY `minOrder` ASC [ RunTime:0.004312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275154 ORDER BY `unit` DESC [ RunTime:0.008367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275154 LIMIT 2 [ RunTime:0.009095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275154 ORDER BY `minOrder` ASC [ RunTime:0.008338s ]
select * from pdf where partno='796861-2' and brandshort='te connectivity' limit 1 [ RunTime:0.005894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796861-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.019190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275391 LIMIT 5 [ RunTime:0.005698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275391 ORDER BY `minOrder` ASC [ RunTime:0.004708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275391 ORDER BY `unit` DESC [ RunTime:0.013203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275391 LIMIT 2 [ RunTime:0.006951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275391 ORDER BY `minOrder` ASC [ RunTime:0.000916s ]
select * from pdf where partno='796638-8' and brandshort='te connectivity' limit 1 [ RunTime:0.006572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796638-8' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.027923s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478459 LIMIT 5 [ RunTime:0.005005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478459 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478459 ORDER BY `unit` DESC [ RunTime:0.002994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478459 LIMIT 2 [ RunTime:0.001081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478459 ORDER BY `minOrder` ASC [ RunTime:0.001527s ]
select * from pdf where partno='796638-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796638-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005936s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478459 AND `partno` = '796638-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649389 [ RunTime:0.005318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60483209 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60483209 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60483209 ORDER BY `unit` DESC [ RunTime:0.001913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60483209 LIMIT 2 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60483209 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='796636-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796636-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001605s ]
SELECT `id` FROM `stock` WHERE `id` <> 60483209 AND `partno` = '796636-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11445866 [ RunTime:0.000405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478519 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478519 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478519 ORDER BY `unit` DESC [ RunTime:0.001462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478519 LIMIT 2 [ RunTime:0.007940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478519 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='796642-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796642-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002144s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478519 AND `partno` = '796642-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451534 [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478675 LIMIT 5 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478675 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478675 ORDER BY `unit` DESC [ RunTime:0.000257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478675 LIMIT 2 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478675 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
select * from pdf where partno='796644-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796644-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000548s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478675 AND `partno` = '796644-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657398 [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478879 LIMIT 5 [ RunTime:0.015382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478879 ORDER BY `minOrder` ASC [ RunTime:0.001145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478879 ORDER BY `unit` DESC [ RunTime:0.002324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478879 LIMIT 2 [ RunTime:0.010146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478879 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='796642-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796642-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006132s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478879 AND `partno` = '796642-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605236 [ RunTime:0.001045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484469 LIMIT 5 [ RunTime:0.002474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484469 ORDER BY `minOrder` ASC [ RunTime:0.007226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484469 ORDER BY `unit` DESC [ RunTime:0.002217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484469 LIMIT 2 [ RunTime:0.023600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484469 ORDER BY `minOrder` ASC [ RunTime:0.004385s ]
select * from pdf where partno='796867-9' and brandshort='TE Connectivity' limit 1 [ RunTime:0.007470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796867-9' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.024864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478900 LIMIT 5 [ RunTime:0.007338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478900 ORDER BY `minOrder` ASC [ RunTime:0.007937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478900 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478900 LIMIT 2 [ RunTime:0.004027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478900 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
select * from pdf where partno='796644-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796644-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002607s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478900 AND `partno` = '796644-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605748 [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60479124 LIMIT 5 [ RunTime:0.008885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479124 ORDER BY `minOrder` ASC [ RunTime:0.005583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60479124 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60479124 LIMIT 2 [ RunTime:0.002093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479124 ORDER BY `minOrder` ASC [ RunTime:0.007134s ]
select * from pdf where partno='796636-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796636-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000773s ]
SELECT `id` FROM `stock` WHERE `id` <> 60479124 AND `partno` = '796636-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615222 [ RunTime:0.003599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480736 LIMIT 5 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480736 ORDER BY `minOrder` ASC [ RunTime:0.008872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480736 ORDER BY `unit` DESC [ RunTime:0.004770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480736 LIMIT 2 [ RunTime:0.003132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480736 ORDER BY `minOrder` ASC [ RunTime:0.003296s ]
select * from pdf where partno='796635-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796635-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003799s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480736 AND `partno` = '796635-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19607865 [ RunTime:0.002488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484361 LIMIT 5 [ RunTime:0.003273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484361 ORDER BY `minOrder` ASC [ RunTime:0.002785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484361 ORDER BY `unit` DESC [ RunTime:0.010961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484361 LIMIT 2 [ RunTime:0.006578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484361 ORDER BY `minOrder` ASC [ RunTime:0.007629s ]
select * from pdf where partno='796634-3' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796634-3' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.022760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60322531 LIMIT 5 [ RunTime:0.043951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60322531 ORDER BY `minOrder` ASC [ RunTime:0.045351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60322531 ORDER BY `unit` DESC [ RunTime:0.031633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60322531 LIMIT 2 [ RunTime:0.007262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60322531 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
select * from pdf where partno='796075-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796075-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019779s ]
SELECT `id` FROM `stock` WHERE `id` <> 60322531 AND `partno` = '796075-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11689143 [ RunTime:0.012973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60559889 LIMIT 5 [ RunTime:0.022190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559889 ORDER BY `minOrder` ASC [ RunTime:0.023219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60559889 ORDER BY `unit` DESC [ RunTime:0.009696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60559889 LIMIT 2 [ RunTime:0.016220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559889 ORDER BY `minOrder` ASC [ RunTime:0.001533s ]
select * from pdf where partno='796690-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796690-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.042847s ]
SELECT `id` FROM `stock` WHERE `id` <> 60559889 AND `partno` = '796690-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.029130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11443533 [ RunTime:0.030215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60481546 LIMIT 5 [ RunTime:0.021606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481546 ORDER BY `minOrder` ASC [ RunTime:0.057292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60481546 ORDER BY `unit` DESC [ RunTime:0.049421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60481546 LIMIT 2 [ RunTime:0.006717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481546 ORDER BY `minOrder` ASC [ RunTime:0.011566s ]
select * from pdf where partno='796644-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796644-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.073076s ]
SELECT `id` FROM `stock` WHERE `id` <> 60481546 AND `partno` = '796644-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.026521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615174 [ RunTime:0.020365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478145 LIMIT 5 [ RunTime:0.041236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478145 ORDER BY `minOrder` ASC [ RunTime:0.050111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478145 ORDER BY `unit` DESC [ RunTime:0.017013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478145 LIMIT 2 [ RunTime:0.029183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478145 ORDER BY `minOrder` ASC [ RunTime:0.009694s ]
select * from pdf where partno='796640-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796640-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011478s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478145 AND `partno` = '796640-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15444438 [ RunTime:0.041268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60477913 LIMIT 5 [ RunTime:0.014551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477913 ORDER BY `minOrder` ASC [ RunTime:0.018275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60477913 ORDER BY `unit` DESC [ RunTime:0.024726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60477913 LIMIT 2 [ RunTime:0.016896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477913 ORDER BY `minOrder` ASC [ RunTime:0.024232s ]
select * from pdf where partno='796634-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796634-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008860s ]
SELECT `id` FROM `stock` WHERE `id` <> 60477913 AND `partno` = '796634-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.018410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19610339 [ RunTime:0.020264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60559445 LIMIT 5 [ RunTime:0.007889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559445 ORDER BY `minOrder` ASC [ RunTime:0.011918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60559445 ORDER BY `unit` DESC [ RunTime:0.010689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60559445 LIMIT 2 [ RunTime:0.010925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559445 ORDER BY `minOrder` ASC [ RunTime:0.006649s ]
select * from pdf where partno='796692-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796692-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010938s ]
SELECT `id` FROM `stock` WHERE `id` <> 60559445 AND `partno` = '796692-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12551558 [ RunTime:0.030277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60479620 LIMIT 5 [ RunTime:0.001994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479620 ORDER BY `minOrder` ASC [ RunTime:0.028883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60479620 ORDER BY `unit` DESC [ RunTime:0.000911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60479620 LIMIT 2 [ RunTime:0.017292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479620 ORDER BY `minOrder` ASC [ RunTime:0.010367s ]
select * from pdf where partno='796634-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796634-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017807s ]
SELECT `id` FROM `stock` WHERE `id` <> 60479620 AND `partno` = '796634-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19610401 [ RunTime:0.037217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001647 LIMIT 5 [ RunTime:0.006535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001647 ORDER BY `minOrder` ASC [ RunTime:0.021591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001647 ORDER BY `unit` DESC [ RunTime:0.016616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001647 LIMIT 2 [ RunTime:0.009032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001647 ORDER BY `minOrder` ASC [ RunTime:0.002595s ]
select * from pdf where partno='7969A 0101000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.014937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7969A 0101000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.034320s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001647 AND `partno` = '7969A 0101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.037607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377925 [ RunTime:0.032033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60477927 LIMIT 5 [ RunTime:0.028855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477927 ORDER BY `minOrder` ASC [ RunTime:0.016227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60477927 ORDER BY `unit` DESC [ RunTime:0.049630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60477927 LIMIT 2 [ RunTime:0.015977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477927 ORDER BY `minOrder` ASC [ RunTime:0.006675s ]
select * from pdf where partno='796640-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796640-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020392s ]
SELECT `id` FROM `stock` WHERE `id` <> 60477927 AND `partno` = '796640-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19610322 [ RunTime:0.034077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478870 LIMIT 5 [ RunTime:0.019212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478870 ORDER BY `minOrder` ASC [ RunTime:0.029283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478870 ORDER BY `unit` DESC [ RunTime:0.028025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478870 LIMIT 2 [ RunTime:0.038844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478870 ORDER BY `minOrder` ASC [ RunTime:0.006501s ]
select * from pdf where partno='796635-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '796635-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017919s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478870 AND `partno` = '796635-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17302928 [ RunTime:0.013538s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013179s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008265s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013280s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011546s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010340s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008835s ]
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 '796%' OR `brand` LIKE '796%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018688s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '796%' OR `brand` LIKE '796%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021228s ]