SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002806s ]
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=20413&search=1' [ RunTime:0.002090s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002171s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000750s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002054s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.007125s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001672s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006433s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001619s ]
SELECT * FROM `stock_search` WHERE `partno` = '20413' LIMIT 1 [ RunTime:0.007942s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-23 17:07:00' WHERE `partno` = '20413' [ RunTime:0.015234s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001613s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065335s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16355884 LIMIT 5 [ RunTime:0.018058s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16355884 ORDER BY `minOrder` ASC [ RunTime:0.017948s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16355884 ORDER BY `unit` DESC [ RunTime:0.014549s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16355884 LIMIT 2 [ RunTime:0.015228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16355884 ORDER BY `minOrder` ASC [ RunTime:0.005596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354333 LIMIT 5 [ RunTime:0.006780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354333 ORDER BY `minOrder` ASC [ RunTime:0.046102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354333 ORDER BY `unit` DESC [ RunTime:0.027516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354333 LIMIT 2 [ RunTime:0.059437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354333 ORDER BY `minOrder` ASC [ RunTime:0.032859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074367 LIMIT 5 [ RunTime:0.044325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074367 ORDER BY `minOrder` ASC [ RunTime:0.016997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074367 ORDER BY `unit` DESC [ RunTime:0.008375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074367 LIMIT 2 [ RunTime:0.025444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074367 ORDER BY `minOrder` ASC [ RunTime:0.004044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073595 LIMIT 5 [ RunTime:0.054709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073595 ORDER BY `minOrder` ASC [ RunTime:0.002370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073595 ORDER BY `unit` DESC [ RunTime:0.054440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073595 LIMIT 2 [ RunTime:0.045997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073595 ORDER BY `minOrder` ASC [ RunTime:0.011865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417488 LIMIT 5 [ RunTime:0.033542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417488 ORDER BY `minOrder` ASC [ RunTime:0.044783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417488 ORDER BY `unit` DESC [ RunTime:0.060945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417488 LIMIT 2 [ RunTime:0.052490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417488 ORDER BY `minOrder` ASC [ RunTime:0.018378s ]
select * from pdf where partno='20413.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.073256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524869 LIMIT 5 [ RunTime:0.018997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524869 ORDER BY `minOrder` ASC [ RunTime:0.041385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524869 ORDER BY `unit` DESC [ RunTime:0.051591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524869 LIMIT 2 [ RunTime:0.042713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524869 ORDER BY `minOrder` ASC [ RunTime:0.017984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13307493 LIMIT 5 [ RunTime:0.005076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307493 ORDER BY `minOrder` ASC [ RunTime:0.025524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13307493 ORDER BY `unit` DESC [ RunTime:0.014567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13307493 LIMIT 2 [ RunTime:0.008315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307493 ORDER BY `minOrder` ASC [ RunTime:0.009441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13196076 LIMIT 5 [ RunTime:0.012281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13196076 ORDER BY `minOrder` ASC [ RunTime:0.005348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13196076 ORDER BY `unit` DESC [ RunTime:0.003712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13196076 LIMIT 2 [ RunTime:0.023637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13196076 ORDER BY `minOrder` ASC [ RunTime:0.005485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12816476 LIMIT 5 [ RunTime:0.003255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12816476 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12816476 ORDER BY `unit` DESC [ RunTime:0.011590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12816476 LIMIT 2 [ RunTime:0.005628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12816476 ORDER BY `minOrder` ASC [ RunTime:0.013801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781854 LIMIT 5 [ RunTime:0.002556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781854 ORDER BY `minOrder` ASC [ RunTime:0.004341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781854 ORDER BY `unit` DESC [ RunTime:0.023023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781854 LIMIT 2 [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781854 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12770377 LIMIT 5 [ RunTime:0.004611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12770377 ORDER BY `minOrder` ASC [ RunTime:0.002032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12770377 ORDER BY `unit` DESC [ RunTime:0.001235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12770377 LIMIT 2 [ RunTime:0.003207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12770377 ORDER BY `minOrder` ASC [ RunTime:0.004797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12770376 LIMIT 5 [ RunTime:0.027466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12770376 ORDER BY `minOrder` ASC [ RunTime:0.011506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12770376 ORDER BY `unit` DESC [ RunTime:0.002201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12770376 LIMIT 2 [ RunTime:0.001724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12770376 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11933935 LIMIT 5 [ RunTime:0.006655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11933935 ORDER BY `minOrder` ASC [ RunTime:0.011363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11933935 ORDER BY `unit` DESC [ RunTime:0.001487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11933935 LIMIT 2 [ RunTime:0.001629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11933935 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11933446 LIMIT 5 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11933446 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11933446 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11933446 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11933446 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11867511 LIMIT 5 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11867511 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11867511 ORDER BY `unit` DESC [ RunTime:0.005553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11867511 LIMIT 2 [ RunTime:0.004176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11867511 ORDER BY `minOrder` ASC [ RunTime:0.004862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11663588 LIMIT 5 [ RunTime:0.004212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11663588 ORDER BY `minOrder` ASC [ RunTime:0.006137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11663588 ORDER BY `unit` DESC [ RunTime:0.004253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11663588 LIMIT 2 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11663588 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11652687 LIMIT 5 [ RunTime:0.003891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11652687 ORDER BY `minOrder` ASC [ RunTime:0.009971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11652687 ORDER BY `unit` DESC [ RunTime:0.001098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11652687 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11652687 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11595497 LIMIT 5 [ RunTime:0.004239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11595497 ORDER BY `minOrder` ASC [ RunTime:0.011027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11595497 ORDER BY `unit` DESC [ RunTime:0.004882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11595497 LIMIT 2 [ RunTime:0.007256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11595497 ORDER BY `minOrder` ASC [ RunTime:0.003390s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001188s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418599 LIMIT 5 [ RunTime:0.001677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418599 ORDER BY `minOrder` ASC [ RunTime:0.001827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418599 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418599 LIMIT 2 [ RunTime:0.002193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418599 ORDER BY `minOrder` ASC [ RunTime:0.002925s ]
select * from pdf where partno='2041376-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000734s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041376-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.027667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418628 LIMIT 5 [ RunTime:0.007586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418628 ORDER BY `minOrder` ASC [ RunTime:0.014707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418628 ORDER BY `unit` DESC [ RunTime:0.013210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418628 LIMIT 2 [ RunTime:0.006650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418628 ORDER BY `minOrder` ASC [ RunTime:0.001725s ]
select * from pdf where partno='2041307-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041307-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003151s ]
SELECT `id` FROM `stock` WHERE `id` <> 60418628 AND `partno` = '2041307-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16355884 [ RunTime:0.007032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514567 LIMIT 5 [ RunTime:0.009784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514567 ORDER BY `minOrder` ASC [ RunTime:0.019194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514567 ORDER BY `unit` DESC [ RunTime:0.010816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514567 LIMIT 2 [ RunTime:0.003613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514567 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
select * from pdf where partno='20413' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20413' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008351s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514567 AND `partno` = '20413' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.020395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524869 [ RunTime:0.008698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146731 LIMIT 5 [ RunTime:0.002915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146731 ORDER BY `minOrder` ASC [ RunTime:0.001272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146731 ORDER BY `unit` DESC [ RunTime:0.003648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146731 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146731 ORDER BY `minOrder` ASC [ RunTime:0.006547s ]
select * from pdf where partno='20413.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.000521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20413.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004067s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146731 AND `partno` = '20413.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.009086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417488 [ RunTime:0.000796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61950557 LIMIT 5 [ RunTime:0.002090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61950557 ORDER BY `minOrder` ASC [ RunTime:0.004254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61950557 ORDER BY `unit` DESC [ RunTime:0.000953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61950557 LIMIT 2 [ RunTime:0.003272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61950557 ORDER BY `minOrder` ASC [ RunTime:0.000961s ]
select * from pdf where partno='2041372-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041372-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000775s ]
SELECT `id` FROM `stock` WHERE `id` <> 61950557 AND `partno` = '2041372-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11867511 [ RunTime:0.003505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60424392 LIMIT 5 [ RunTime:0.013277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60424392 ORDER BY `minOrder` ASC [ RunTime:0.016328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60424392 ORDER BY `unit` DESC [ RunTime:0.002459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60424392 LIMIT 2 [ RunTime:0.006964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60424392 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='2041376-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041376-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014128s ]
SELECT `id` FROM `stock` WHERE `id` <> 60424392 AND `partno` = '2041376-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074367 [ RunTime:0.000493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60422957 LIMIT 5 [ RunTime:0.004389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422957 ORDER BY `minOrder` ASC [ RunTime:0.011929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60422957 ORDER BY `unit` DESC [ RunTime:0.022003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60422957 LIMIT 2 [ RunTime:0.011987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422957 ORDER BY `minOrder` ASC [ RunTime:0.005333s ]
select * from pdf where partno='2041307-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041307-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001187s ]
SELECT `id` FROM `stock` WHERE `id` <> 60422957 AND `partno` = '2041307-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073595 [ RunTime:0.006829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419200 LIMIT 5 [ RunTime:0.004115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419200 ORDER BY `minOrder` ASC [ RunTime:0.011786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419200 ORDER BY `unit` DESC [ RunTime:0.014931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419200 LIMIT 2 [ RunTime:0.018791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419200 ORDER BY `minOrder` ASC [ RunTime:0.001403s ]
select * from pdf where partno='2041376-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041376-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011466s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419200 AND `partno` = '2041376-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354333 [ RunTime:0.012758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372474 LIMIT 5 [ RunTime:0.006160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372474 ORDER BY `minOrder` ASC [ RunTime:0.009215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372474 ORDER BY `unit` DESC [ RunTime:0.011492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372474 LIMIT 2 [ RunTime:0.043973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372474 ORDER BY `minOrder` ASC [ RunTime:0.007864s ]
select * from pdf where partno='204131-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.030073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '204131-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.007201s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372474 AND `partno` = '204131-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.026032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59397382 LIMIT 5 [ RunTime:0.003502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59397382 ORDER BY `minOrder` ASC [ RunTime:0.030018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59397382 ORDER BY `unit` DESC [ RunTime:0.021907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59397382 LIMIT 2 [ RunTime:0.018086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59397382 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='2041335-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041335-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017225s ]
SELECT `id` FROM `stock` WHERE `id` <> 59397382 AND `partno` = '2041335-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.024211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13196076 [ RunTime:0.013861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59396589 LIMIT 5 [ RunTime:0.009658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59396589 ORDER BY `minOrder` ASC [ RunTime:0.041101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59396589 ORDER BY `unit` DESC [ RunTime:0.042977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59396589 LIMIT 2 [ RunTime:0.047131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59396589 ORDER BY `minOrder` ASC [ RunTime:0.022041s ]
select * from pdf where partno='2041386-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041386-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.032406s ]
SELECT `id` FROM `stock` WHERE `id` <> 59396589 AND `partno` = '2041386-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.046949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11933446 [ RunTime:0.050088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59367655 LIMIT 5 [ RunTime:0.034419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59367655 ORDER BY `minOrder` ASC [ RunTime:0.061658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59367655 ORDER BY `unit` DESC [ RunTime:0.121177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59367655 LIMIT 2 [ RunTime:0.023738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59367655 ORDER BY `minOrder` ASC [ RunTime:0.020928s ]
select * from pdf where partno='2041314-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041314-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.021006s ]
SELECT `id` FROM `stock` WHERE `id` <> 59367655 AND `partno` = '2041314-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781854 [ RunTime:0.021497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58985846 LIMIT 5 [ RunTime:0.010822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58985846 ORDER BY `minOrder` ASC [ RunTime:0.033941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58985846 ORDER BY `unit` DESC [ RunTime:0.010686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58985846 LIMIT 2 [ RunTime:0.023995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58985846 ORDER BY `minOrder` ASC [ RunTime:0.023704s ]
select * from pdf where partno='2041313-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.059662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041313-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.048059s ]
SELECT `id` FROM `stock` WHERE `id` <> 58985846 AND `partno` = '2041313-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12816476 [ RunTime:0.009663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58842255 LIMIT 5 [ RunTime:0.025748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58842255 ORDER BY `minOrder` ASC [ RunTime:0.027574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58842255 ORDER BY `unit` DESC [ RunTime:0.077262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58842255 LIMIT 2 [ RunTime:0.039187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58842255 ORDER BY `minOrder` ASC [ RunTime:0.014459s ]
select * from pdf where partno='2041366-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.051373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041366-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027476s ]
SELECT `id` FROM `stock` WHERE `id` <> 58842255 AND `partno` = '2041366-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.028998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11663588 [ RunTime:0.046992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58813875 LIMIT 5 [ RunTime:0.041079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58813875 ORDER BY `minOrder` ASC [ RunTime:0.027128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58813875 ORDER BY `unit` DESC [ RunTime:0.057341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58813875 LIMIT 2 [ RunTime:0.061836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58813875 ORDER BY `minOrder` ASC [ RunTime:0.016693s ]
select * from pdf where partno='2041313-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.023821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041313-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016186s ]
SELECT `id` FROM `stock` WHERE `id` <> 58813875 AND `partno` = '2041313-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11652687 [ RunTime:0.000577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32621096 LIMIT 5 [ RunTime:0.019494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32621096 ORDER BY `minOrder` ASC [ RunTime:0.003644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32621096 ORDER BY `unit` DESC [ RunTime:0.011477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32621096 LIMIT 2 [ RunTime:0.014653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32621096 ORDER BY `minOrder` ASC [ RunTime:0.004178s ]
select * from pdf where partno='20413002' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.046325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20413002' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003050s ]
SELECT `id` FROM `stock` WHERE `id` <> 32621096 AND `partno` = '20413002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32342531 LIMIT 5 [ RunTime:0.034612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32342531 ORDER BY `minOrder` ASC [ RunTime:0.038671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32342531 ORDER BY `unit` DESC [ RunTime:0.037753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32342531 LIMIT 2 [ RunTime:0.015872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32342531 ORDER BY `minOrder` ASC [ RunTime:0.006830s ]
select * from pdf where partno='2041398-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.032448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2041398-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020826s ]
SELECT `id` FROM `stock` WHERE `id` <> 32342531 AND `partno` = '2041398-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.050234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13307493 [ RunTime:0.035299s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046659s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052734s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070198s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042562s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013803s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062307s ]
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 '20413%' OR `brand` LIKE '20413%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053960s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20413%' OR `brand` LIKE '20413%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.051689s ]