SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001134s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=60107&search=1' [ RunTime:0.002606s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001113s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007493s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001285s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.001278s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001206s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004872s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002251s ]
SELECT * FROM `stock_search` WHERE `partno` = '60107' LIMIT 1 [ RunTime:0.002970s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 22:20:07' WHERE `partno` = '60107' [ RunTime:0.011421s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002556s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010845s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16426427 LIMIT 5 [ RunTime:0.018003s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16426427 ORDER BY `minOrder` ASC [ RunTime:0.007935s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16426427 ORDER BY `unit` DESC [ RunTime:0.020002s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16426427 LIMIT 2 [ RunTime:0.020410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16426427 ORDER BY `minOrder` ASC [ RunTime:0.020760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13542573 LIMIT 5 [ RunTime:0.022641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13542573 ORDER BY `minOrder` ASC [ RunTime:0.050396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13542573 ORDER BY `unit` DESC [ RunTime:0.024294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13542573 LIMIT 2 [ RunTime:0.048770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13542573 ORDER BY `minOrder` ASC [ RunTime:0.014309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13249414 LIMIT 5 [ RunTime:0.055557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13249414 ORDER BY `minOrder` ASC [ RunTime:0.055472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13249414 ORDER BY `unit` DESC [ RunTime:0.050428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13249414 LIMIT 2 [ RunTime:0.030502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13249414 ORDER BY `minOrder` ASC [ RunTime:0.061195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17000172 LIMIT 5 [ RunTime:0.079989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17000172 ORDER BY `minOrder` ASC [ RunTime:0.048029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17000172 ORDER BY `unit` DESC [ RunTime:0.032576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17000172 LIMIT 2 [ RunTime:0.001596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17000172 ORDER BY `minOrder` ASC [ RunTime:0.052233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160786 LIMIT 5 [ RunTime:0.030712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160786 ORDER BY `minOrder` ASC [ RunTime:0.045041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12160786 ORDER BY `unit` DESC [ RunTime:0.004074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12160786 LIMIT 2 [ RunTime:0.001255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160786 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18744078 LIMIT 5 [ RunTime:0.026016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18744078 ORDER BY `minOrder` ASC [ RunTime:0.004111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18744078 ORDER BY `unit` DESC [ RunTime:0.027628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18744078 LIMIT 2 [ RunTime:0.021463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18744078 ORDER BY `minOrder` ASC [ RunTime:0.003818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18722258 LIMIT 5 [ RunTime:0.011751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18722258 ORDER BY `minOrder` ASC [ RunTime:0.008650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18722258 ORDER BY `unit` DESC [ RunTime:0.012641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18722258 LIMIT 2 [ RunTime:0.001804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18722258 ORDER BY `minOrder` ASC [ RunTime:0.016031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18721462 LIMIT 5 [ RunTime:0.009515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18721462 ORDER BY `minOrder` ASC [ RunTime:0.010188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18721462 ORDER BY `unit` DESC [ RunTime:0.020523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18721462 LIMIT 2 [ RunTime:0.006247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18721462 ORDER BY `minOrder` ASC [ RunTime:0.009699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17501628 LIMIT 5 [ RunTime:0.012237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17501628 ORDER BY `minOrder` ASC [ RunTime:0.007202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17501628 ORDER BY `unit` DESC [ RunTime:0.004811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17501628 LIMIT 2 [ RunTime:0.016958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17501628 ORDER BY `minOrder` ASC [ RunTime:0.001014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17497048 LIMIT 5 [ RunTime:0.007489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17497048 ORDER BY `minOrder` ASC [ RunTime:0.001409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17497048 ORDER BY `unit` DESC [ RunTime:0.004951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17497048 LIMIT 2 [ RunTime:0.003282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17497048 ORDER BY `minOrder` ASC [ RunTime:0.001956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14687188 LIMIT 5 [ RunTime:0.007325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687188 ORDER BY `minOrder` ASC [ RunTime:0.010717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14687188 ORDER BY `unit` DESC [ RunTime:0.008275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14687188 LIMIT 2 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687188 ORDER BY `minOrder` ASC [ RunTime:0.004921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014887 LIMIT 5 [ RunTime:0.016176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014887 ORDER BY `minOrder` ASC [ RunTime:0.003176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12014887 ORDER BY `unit` DESC [ RunTime:0.009139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12014887 LIMIT 2 [ RunTime:0.020708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014887 ORDER BY `minOrder` ASC [ RunTime:0.001709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193537 LIMIT 5 [ RunTime:0.014109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193537 ORDER BY `minOrder` ASC [ RunTime:0.001054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193537 ORDER BY `unit` DESC [ RunTime:0.003000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193537 LIMIT 2 [ RunTime:0.014191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193537 ORDER BY `minOrder` ASC [ RunTime:0.012332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11179207 LIMIT 5 [ RunTime:0.020273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11179207 ORDER BY `minOrder` ASC [ RunTime:0.008238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11179207 ORDER BY `unit` DESC [ RunTime:0.028199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11179207 LIMIT 2 [ RunTime:0.015876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11179207 ORDER BY `minOrder` ASC [ RunTime:0.009486s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029770s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56253456 LIMIT 5 [ RunTime:0.015441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56253456 ORDER BY `minOrder` ASC [ RunTime:0.032654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56253456 ORDER BY `unit` DESC [ RunTime:0.013665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56253456 LIMIT 2 [ RunTime:0.044556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56253456 ORDER BY `minOrder` ASC [ RunTime:0.018183s ]
select * from pdf where partno='601072-000' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.038925s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601072-000' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.060270s ]
SELECT `id` FROM `stock` WHERE `id` <> 56253456 AND `partno` = '601072-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.029610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16426427 [ RunTime:0.015513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56253634 LIMIT 5 [ RunTime:0.017632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56253634 ORDER BY `minOrder` ASC [ RunTime:0.013878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56253634 ORDER BY `unit` DESC [ RunTime:0.009927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56253634 LIMIT 2 [ RunTime:0.009882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56253634 ORDER BY `minOrder` ASC [ RunTime:0.006203s ]
select * from pdf where partno='601071-000' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.009119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601071-000' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.003918s ]
SELECT `id` FROM `stock` WHERE `id` <> 56253634 AND `partno` = '601071-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.024657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13542573 [ RunTime:0.005774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56459036 LIMIT 5 [ RunTime:0.015578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56459036 ORDER BY `minOrder` ASC [ RunTime:0.026824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56459036 ORDER BY `unit` DESC [ RunTime:0.016420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56459036 LIMIT 2 [ RunTime:0.006447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56459036 ORDER BY `minOrder` ASC [ RunTime:0.017711s ]
select * from pdf where partno='601072' and brandshort='Dracal Technologies' limit 1 [ RunTime:0.005433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601072' OR `brand` LIKE 'Dracal Technologies%' ) ) LIMIT 1 [ RunTime:0.028816s ]
SELECT `id` FROM `stock` WHERE `id` <> 56459036 AND `partno` = '601072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dracal technologies%' ) [ RunTime:0.001664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13249414 [ RunTime:0.003178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58527034 LIMIT 5 [ RunTime:0.005754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527034 ORDER BY `minOrder` ASC [ RunTime:0.003067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58527034 ORDER BY `unit` DESC [ RunTime:0.002677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58527034 LIMIT 2 [ RunTime:0.003578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527034 ORDER BY `minOrder` ASC [ RunTime:0.005847s ]
select * from pdf where partno='601075' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601075' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.003498s ]
SELECT `id` FROM `stock` WHERE `id` <> 58527034 AND `partno` = '601075' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.012022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44626325 LIMIT 5 [ RunTime:0.015194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626325 ORDER BY `minOrder` ASC [ RunTime:0.004731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44626325 ORDER BY `unit` DESC [ RunTime:0.002680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44626325 LIMIT 2 [ RunTime:0.002291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626325 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
select * from pdf where partno='601075' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.010751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601075' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.020582s ]
SELECT `id` FROM `stock` WHERE `id` <> 44626325 AND `partno` = '601075' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.008594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18721462 [ RunTime:0.006554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33107626 LIMIT 5 [ RunTime:0.011002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107626 ORDER BY `minOrder` ASC [ RunTime:0.007056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33107626 ORDER BY `unit` DESC [ RunTime:0.012699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33107626 LIMIT 2 [ RunTime:0.008530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107626 ORDER BY `minOrder` ASC [ RunTime:0.005435s ]
select * from pdf where partno='601075' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.010052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601075' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000916s ]
SELECT `id` FROM `stock` WHERE `id` <> 33107626 AND `partno` = '601075' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.017537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18721462 [ RunTime:0.002888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58527046 LIMIT 5 [ RunTime:0.017374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527046 ORDER BY `minOrder` ASC [ RunTime:0.005204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58527046 ORDER BY `unit` DESC [ RunTime:0.015082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58527046 LIMIT 2 [ RunTime:0.002893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527046 ORDER BY `minOrder` ASC [ RunTime:0.001824s ]
select * from pdf where partno='601075-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.008865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601075-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.019196s ]
SELECT `id` FROM `stock` WHERE `id` <> 58527046 AND `partno` = '601075-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.021526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44626338 LIMIT 5 [ RunTime:0.035617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626338 ORDER BY `minOrder` ASC [ RunTime:0.007104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44626338 ORDER BY `unit` DESC [ RunTime:0.029935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44626338 LIMIT 2 [ RunTime:0.014375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626338 ORDER BY `minOrder` ASC [ RunTime:0.013959s ]
select * from pdf where partno='601075-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.007213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601075-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.012267s ]
SELECT `id` FROM `stock` WHERE `id` <> 44626338 AND `partno` = '601075-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.015677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18722258 [ RunTime:0.017951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33107637 LIMIT 5 [ RunTime:0.035863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107637 ORDER BY `minOrder` ASC [ RunTime:0.009036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33107637 ORDER BY `unit` DESC [ RunTime:0.043142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33107637 LIMIT 2 [ RunTime:0.033292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107637 ORDER BY `minOrder` ASC [ RunTime:0.005841s ]
select * from pdf where partno='601075-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.036465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601075-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.015067s ]
SELECT `id` FROM `stock` WHERE `id` <> 33107637 AND `partno` = '601075-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.032852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18722258 [ RunTime:0.012920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58586656 LIMIT 5 [ RunTime:0.005184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586656 ORDER BY `minOrder` ASC [ RunTime:0.013614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58586656 ORDER BY `unit` DESC [ RunTime:0.031673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58586656 LIMIT 2 [ RunTime:0.037283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586656 ORDER BY `minOrder` ASC [ RunTime:0.018680s ]
select * from pdf where partno='60107RL' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.056631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60107RL' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.032710s ]
SELECT `id` FROM `stock` WHERE `id` <> 58586656 AND `partno` = '60107RL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.016930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160786 [ RunTime:0.011759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58587225 LIMIT 5 [ RunTime:0.008587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58587225 ORDER BY `minOrder` ASC [ RunTime:0.012726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58587225 ORDER BY `unit` DESC [ RunTime:0.008639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58587225 LIMIT 2 [ RunTime:0.018174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58587225 ORDER BY `minOrder` ASC [ RunTime:0.015002s ]
select * from pdf where partno='60107' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.007364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60107' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.134547s ]
SELECT `id` FROM `stock` WHERE `id` <> 58587225 AND `partno` = '60107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.131296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11179207 [ RunTime:0.003775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55378121 LIMIT 5 [ RunTime:0.128238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55378121 ORDER BY `minOrder` ASC [ RunTime:0.064244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55378121 ORDER BY `unit` DESC [ RunTime:0.026131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55378121 LIMIT 2 [ RunTime:0.079672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55378121 ORDER BY `minOrder` ASC [ RunTime:0.008394s ]
select * from pdf where partno='6010748' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.045661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6010748' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.058814s ]
SELECT `id` FROM `stock` WHERE `id` <> 55378121 AND `partno` = '6010748' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.053059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17501628 [ RunTime:0.033590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55370053 LIMIT 5 [ RunTime:0.058246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55370053 ORDER BY `minOrder` ASC [ RunTime:0.028556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55370053 ORDER BY `unit` DESC [ RunTime:0.026058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55370053 LIMIT 2 [ RunTime:0.074379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55370053 ORDER BY `minOrder` ASC [ RunTime:0.106171s ]
select * from pdf where partno='6010754' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6010754' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039044s ]
SELECT `id` FROM `stock` WHERE `id` <> 55370053 AND `partno` = '6010754' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.066726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17497048 [ RunTime:0.018329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44031738 LIMIT 5 [ RunTime:0.068092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44031738 ORDER BY `minOrder` ASC [ RunTime:0.101090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44031738 ORDER BY `unit` DESC [ RunTime:0.037692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44031738 LIMIT 2 [ RunTime:0.099508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44031738 ORDER BY `minOrder` ASC [ RunTime:0.073500s ]
select * from pdf where partno='601078' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.052149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601078' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.103771s ]
SELECT `id` FROM `stock` WHERE `id` <> 44031738 AND `partno` = '601078' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.105048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18744078 [ RunTime:0.112885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44006882 LIMIT 5 [ RunTime:0.121288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44006882 ORDER BY `minOrder` ASC [ RunTime:0.075855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44006882 ORDER BY `unit` DESC [ RunTime:0.096747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44006882 LIMIT 2 [ RunTime:0.152392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44006882 ORDER BY `minOrder` ASC [ RunTime:0.103814s ]
select * from pdf where partno='601077' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.099216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '601077' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.051181s ]
SELECT `id` FROM `stock` WHERE `id` <> 44006882 AND `partno` = '601077' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.056575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17000172 [ RunTime:0.102023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32358781 LIMIT 5 [ RunTime:0.092484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32358781 ORDER BY `minOrder` ASC [ RunTime:0.118175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32358781 ORDER BY `unit` DESC [ RunTime:0.097010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32358781 LIMIT 2 [ RunTime:0.063797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32358781 ORDER BY `minOrder` ASC [ RunTime:0.126482s ]
select * from pdf where partno='6010712' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.102782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6010712' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.051422s ]
SELECT `id` FROM `stock` WHERE `id` <> 32358781 AND `partno` = '6010712' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.051159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014887 [ RunTime:0.056398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32325021 LIMIT 5 [ RunTime:0.052950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325021 ORDER BY `minOrder` ASC [ RunTime:0.038879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32325021 ORDER BY `unit` DESC [ RunTime:0.166654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32325021 LIMIT 2 [ RunTime:0.098140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325021 ORDER BY `minOrder` ASC [ RunTime:0.084849s ]
select * from pdf where partno='60107001' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.191462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60107001' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.051301s ]
SELECT `id` FROM `stock` WHERE `id` <> 32325021 AND `partno` = '60107001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.125549s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.134400s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052103s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051454s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043451s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044939s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070285s ]
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 '60107%' OR `brand` LIKE '60107%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.127964s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60107%' OR `brand` LIKE '60107%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.064289s ]