SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002405s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.142' , `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=202K174-25-0&search=1' [ RunTime:0.001940s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002176s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.052929s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001638s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.142' ) [ RunTime:0.002333s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001213s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002350s ]
SELECT * FROM `stock_search` WHERE `partno` = '202K174-25-0' LIMIT 1 [ RunTime:0.008806s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-02 02:19:55' WHERE `partno` = '202K174-25-0' [ RunTime:0.017101s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001368s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010399s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13561822 LIMIT 5 [ RunTime:0.014938s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13561822 ORDER BY `minOrder` ASC [ RunTime:0.016279s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.033697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13561822 ORDER BY `unit` DESC [ RunTime:0.015475s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13561822 LIMIT 2 [ RunTime:0.040059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13561822 ORDER BY `minOrder` ASC [ RunTime:0.028951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431383 LIMIT 5 [ RunTime:0.032676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431383 ORDER BY `minOrder` ASC [ RunTime:0.035868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431383 ORDER BY `unit` DESC [ RunTime:0.024592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431383 LIMIT 2 [ RunTime:0.047239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431383 ORDER BY `minOrder` ASC [ RunTime:0.013134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431382 LIMIT 5 [ RunTime:0.032746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431382 ORDER BY `minOrder` ASC [ RunTime:0.061693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431382 ORDER BY `unit` DESC [ RunTime:0.042102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431382 LIMIT 2 [ RunTime:0.131032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431382 ORDER BY `minOrder` ASC [ RunTime:0.087971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431197 LIMIT 5 [ RunTime:0.065111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431197 ORDER BY `minOrder` ASC [ RunTime:0.045112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431197 ORDER BY `unit` DESC [ RunTime:0.047513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431197 LIMIT 2 [ RunTime:0.069865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431197 ORDER BY `minOrder` ASC [ RunTime:0.022023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431138 LIMIT 5 [ RunTime:0.033874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431138 ORDER BY `minOrder` ASC [ RunTime:0.029984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431138 ORDER BY `unit` DESC [ RunTime:0.074788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431138 LIMIT 2 [ RunTime:0.049470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431138 ORDER BY `minOrder` ASC [ RunTime:0.063041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431066 LIMIT 5 [ RunTime:0.031937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431066 ORDER BY `minOrder` ASC [ RunTime:0.067975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431066 ORDER BY `unit` DESC [ RunTime:0.015926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431066 LIMIT 2 [ RunTime:0.066423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431066 ORDER BY `minOrder` ASC [ RunTime:0.035259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14430717 LIMIT 5 [ RunTime:0.027813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14430717 ORDER BY `minOrder` ASC [ RunTime:0.010909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14430717 ORDER BY `unit` DESC [ RunTime:0.052650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14430717 LIMIT 2 [ RunTime:0.023771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14430717 ORDER BY `minOrder` ASC [ RunTime:0.039335s ]
select * from pdf where partno='202K174-25-0CS2131' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.042640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562545 LIMIT 5 [ RunTime:0.009756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562545 ORDER BY `minOrder` ASC [ RunTime:0.046002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13562545 ORDER BY `unit` DESC [ RunTime:0.024213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13562545 LIMIT 2 [ RunTime:0.028228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562545 ORDER BY `minOrder` ASC [ RunTime:0.015613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562509 LIMIT 5 [ RunTime:0.013250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562509 ORDER BY `minOrder` ASC [ RunTime:0.051492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13562509 ORDER BY `unit` DESC [ RunTime:0.052446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13562509 LIMIT 2 [ RunTime:0.041590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562509 ORDER BY `minOrder` ASC [ RunTime:0.006283s ]
select * from pdf where partno='202K174-25-01-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.018667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562503 LIMIT 5 [ RunTime:0.049497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562503 ORDER BY `minOrder` ASC [ RunTime:0.017573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13562503 ORDER BY `unit` DESC [ RunTime:0.015916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13562503 LIMIT 2 [ RunTime:0.000945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562503 ORDER BY `minOrder` ASC [ RunTime:0.005476s ]
select * from pdf where partno='202K174-25-02-CS-1858-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.011478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562493 LIMIT 5 [ RunTime:0.005475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562493 ORDER BY `minOrder` ASC [ RunTime:0.014335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13562493 ORDER BY `unit` DESC [ RunTime:0.037553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13562493 LIMIT 2 [ RunTime:0.031529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562493 ORDER BY `minOrder` ASC [ RunTime:0.009221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10098130 LIMIT 5 [ RunTime:0.022061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10098130 ORDER BY `minOrder` ASC [ RunTime:0.027411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10098130 ORDER BY `unit` DESC [ RunTime:0.055305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10098130 LIMIT 2 [ RunTime:0.056786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10098130 ORDER BY `minOrder` ASC [ RunTime:0.016778s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132898 LIMIT 5 [ RunTime:0.025149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132898 ORDER BY `minOrder` ASC [ RunTime:0.051090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132898 ORDER BY `unit` DESC [ RunTime:0.035687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132898 LIMIT 2 [ RunTime:0.031749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132898 ORDER BY `minOrder` ASC [ RunTime:0.022211s ]
select * from pdf where partno='202k174-25-01/225-0' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.053960s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202k174-25-01/225-0' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.032104s ]
SELECT `id` FROM `stock` WHERE `id` <> 51132898 AND `partno` = '202k174-25-01/225-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.026777s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56361778 LIMIT 5 [ RunTime:0.043559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56361778 ORDER BY `minOrder` ASC [ RunTime:0.030912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56361778 ORDER BY `unit` DESC [ RunTime:0.056030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56361778 LIMIT 2 [ RunTime:0.087454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56361778 ORDER BY `minOrder` ASC [ RunTime:0.007906s ]
select * from pdf where partno='202K174-25-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.039891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-0' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.066686s ]
SELECT `id` FROM `stock` WHERE `id` <> 56361778 AND `partno` = '202K174-25-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.084547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13561822 [ RunTime:0.043325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369389 LIMIT 5 [ RunTime:0.024975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369389 ORDER BY `minOrder` ASC [ RunTime:0.026656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369389 ORDER BY `unit` DESC [ RunTime:0.024325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369389 LIMIT 2 [ RunTime:0.050596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369389 ORDER BY `minOrder` ASC [ RunTime:0.025788s ]
select * from pdf where partno='202K174-25-01/225-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-01/225-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024729s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369389 AND `partno` = '202K174-25-01/225-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.037299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369388 LIMIT 5 [ RunTime:0.021267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369388 ORDER BY `minOrder` ASC [ RunTime:0.022645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369388 ORDER BY `unit` DESC [ RunTime:0.031195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369388 LIMIT 2 [ RunTime:0.016324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369388 ORDER BY `minOrder` ASC [ RunTime:0.007489s ]
select * from pdf where partno='202K174-25-02/225-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.028802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-02/225-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.028597s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369388 AND `partno` = '202K174-25-02/225-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369153 LIMIT 5 [ RunTime:0.024843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369153 ORDER BY `minOrder` ASC [ RunTime:0.008004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369153 ORDER BY `unit` DESC [ RunTime:0.011477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369153 LIMIT 2 [ RunTime:0.009929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369153 ORDER BY `minOrder` ASC [ RunTime:0.009372s ]
select * from pdf where partno='202K174-25-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012006s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369153 AND `partno` = '202K174-25-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369110 LIMIT 5 [ RunTime:0.015336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369110 ORDER BY `minOrder` ASC [ RunTime:0.030122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369110 ORDER BY `unit` DESC [ RunTime:0.012707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369110 LIMIT 2 [ RunTime:0.049114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369110 ORDER BY `minOrder` ASC [ RunTime:0.018896s ]
select * from pdf where partno='202K174-25-01/225-CS-1858' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-01/225-CS-1858' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.039293s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369110 AND `partno` = '202K174-25-01/225-CS-1858' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.043270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369109 LIMIT 5 [ RunTime:0.008392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369109 ORDER BY `minOrder` ASC [ RunTime:0.028769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369109 ORDER BY `unit` DESC [ RunTime:0.052169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369109 LIMIT 2 [ RunTime:0.045003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369109 ORDER BY `minOrder` ASC [ RunTime:0.004300s ]
select * from pdf where partno='202K174-25-02/225-CS-1858' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.045374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-02/225-CS-1858' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008416s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369109 AND `partno` = '202K174-25-02/225-CS-1858' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369060 LIMIT 5 [ RunTime:0.030686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369060 ORDER BY `minOrder` ASC [ RunTime:0.009857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369060 ORDER BY `unit` DESC [ RunTime:0.032360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369060 LIMIT 2 [ RunTime:0.050824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369060 ORDER BY `minOrder` ASC [ RunTime:0.024860s ]
select * from pdf where partno='202K174-25-02-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-02-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.035224s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369060 AND `partno` = '202K174-25-02-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.028083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56368871 LIMIT 5 [ RunTime:0.024993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368871 ORDER BY `minOrder` ASC [ RunTime:0.068533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56368871 ORDER BY `unit` DESC [ RunTime:0.014079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56368871 LIMIT 2 [ RunTime:0.011228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368871 ORDER BY `minOrder` ASC [ RunTime:0.020760s ]
select * from pdf where partno='202K174-25-02-CS-1858-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-02-CS-1858-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.036664s ]
SELECT `id` FROM `stock` WHERE `id` <> 56368871 AND `partno` = '202K174-25-02-CS-1858-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.068501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56368750 LIMIT 5 [ RunTime:0.065853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368750 ORDER BY `minOrder` ASC [ RunTime:0.041106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56368750 ORDER BY `unit` DESC [ RunTime:0.027659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56368750 LIMIT 2 [ RunTime:0.045202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368750 ORDER BY `minOrder` ASC [ RunTime:0.051650s ]
select * from pdf where partno='202K174-25-01/86-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.021650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-01/86-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.069163s ]
SELECT `id` FROM `stock` WHERE `id` <> 56368750 AND `partno` = '202K174-25-01/86-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56368743 LIMIT 5 [ RunTime:0.014834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368743 ORDER BY `minOrder` ASC [ RunTime:0.029372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56368743 ORDER BY `unit` DESC [ RunTime:0.039888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56368743 LIMIT 2 [ RunTime:0.056507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368743 ORDER BY `minOrder` ASC [ RunTime:0.010752s ]
select * from pdf where partno='202K174-25-00/225-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-00/225-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.032365s ]
SELECT `id` FROM `stock` WHERE `id` <> 56368743 AND `partno` = '202K174-25-00/225-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56368669 LIMIT 5 [ RunTime:0.025334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368669 ORDER BY `minOrder` ASC [ RunTime:0.017894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56368669 ORDER BY `unit` DESC [ RunTime:0.032301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56368669 LIMIT 2 [ RunTime:0.023913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368669 ORDER BY `minOrder` ASC [ RunTime:0.015361s ]
select * from pdf where partno='202K174-25-01-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-01-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012131s ]
SELECT `id` FROM `stock` WHERE `id` <> 56368669 AND `partno` = '202K174-25-01-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56368584 LIMIT 5 [ RunTime:0.016093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368584 ORDER BY `minOrder` ASC [ RunTime:0.014817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56368584 ORDER BY `unit` DESC [ RunTime:0.012272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56368584 LIMIT 2 [ RunTime:0.014845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368584 ORDER BY `minOrder` ASC [ RunTime:0.002597s ]
select * from pdf where partno='202K174-25-00-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-00-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011011s ]
SELECT `id` FROM `stock` WHERE `id` <> 56368584 AND `partno` = '202K174-25-00-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56368246 LIMIT 5 [ RunTime:0.010978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368246 ORDER BY `minOrder` ASC [ RunTime:0.019310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56368246 ORDER BY `unit` DESC [ RunTime:0.012985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56368246 LIMIT 2 [ RunTime:0.018733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368246 ORDER BY `minOrder` ASC [ RunTime:0.021506s ]
select * from pdf where partno='202K174-25-02-CS-1858-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.007699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-02-CS-1858-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.012961s ]
SELECT `id` FROM `stock` WHERE `id` <> 56368246 AND `partno` = '202K174-25-02-CS-1858-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.011944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562503 [ RunTime:0.003301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56368040 LIMIT 5 [ RunTime:0.032151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368040 ORDER BY `minOrder` ASC [ RunTime:0.008032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56368040 ORDER BY `unit` DESC [ RunTime:0.034553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56368040 LIMIT 2 [ RunTime:0.019338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56368040 ORDER BY `minOrder` ASC [ RunTime:0.035218s ]
select * from pdf where partno='202K174-25-0CS2131' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.008489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-0CS2131' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.011161s ]
SELECT `id` FROM `stock` WHERE `id` <> 56368040 AND `partno` = '202K174-25-0CS2131' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.020211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14430717 [ RunTime:0.028093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56364543 LIMIT 5 [ RunTime:0.036892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364543 ORDER BY `minOrder` ASC [ RunTime:0.030162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56364543 ORDER BY `unit` DESC [ RunTime:0.028117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56364543 LIMIT 2 [ RunTime:0.041723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364543 ORDER BY `minOrder` ASC [ RunTime:0.037574s ]
select * from pdf where partno='202K174-25-01/225-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.033540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-01/225-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.061274s ]
SELECT `id` FROM `stock` WHERE `id` <> 56364543 AND `partno` = '202K174-25-01/225-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.054900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431383 [ RunTime:0.012488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56364170 LIMIT 5 [ RunTime:0.022953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364170 ORDER BY `minOrder` ASC [ RunTime:0.035356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56364170 ORDER BY `unit` DESC [ RunTime:0.040140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56364170 LIMIT 2 [ RunTime:0.018437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364170 ORDER BY `minOrder` ASC [ RunTime:0.044494s ]
select * from pdf where partno='202K174-25-02/225-CS-1858' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.060957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-02/225-CS-1858' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.046497s ]
SELECT `id` FROM `stock` WHERE `id` <> 56364170 AND `partno` = '202K174-25-02/225-CS-1858' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.047471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10098130 [ RunTime:0.024537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56364169 LIMIT 5 [ RunTime:0.029216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364169 ORDER BY `minOrder` ASC [ RunTime:0.002287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56364169 ORDER BY `unit` DESC [ RunTime:0.023394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56364169 LIMIT 2 [ RunTime:0.044019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364169 ORDER BY `minOrder` ASC [ RunTime:0.004956s ]
select * from pdf where partno='202K174-25-01/225-CS-1858' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.038302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-01/225-CS-1858' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.031462s ]
SELECT `id` FROM `stock` WHERE `id` <> 56364169 AND `partno` = '202K174-25-01/225-CS-1858' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.025379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431197 [ RunTime:0.020773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56364059 LIMIT 5 [ RunTime:0.024070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364059 ORDER BY `minOrder` ASC [ RunTime:0.043558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56364059 ORDER BY `unit` DESC [ RunTime:0.017956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56364059 LIMIT 2 [ RunTime:0.031816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364059 ORDER BY `minOrder` ASC [ RunTime:0.009997s ]
select * from pdf where partno='202K174-25-00/225-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.010635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-00/225-0' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.009621s ]
SELECT `id` FROM `stock` WHERE `id` <> 56364059 AND `partno` = '202K174-25-00/225-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.050905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431138 [ RunTime:0.028993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56364036 LIMIT 5 [ RunTime:0.020723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364036 ORDER BY `minOrder` ASC [ RunTime:0.044463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56364036 ORDER BY `unit` DESC [ RunTime:0.012644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56364036 LIMIT 2 [ RunTime:0.021933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364036 ORDER BY `minOrder` ASC [ RunTime:0.010983s ]
select * from pdf where partno='202K174-25-01/86-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.023704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-01/86-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.025770s ]
SELECT `id` FROM `stock` WHERE `id` <> 56364036 AND `partno` = '202K174-25-01/86-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.025387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562545 [ RunTime:0.014800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56363959 LIMIT 5 [ RunTime:0.018615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56363959 ORDER BY `minOrder` ASC [ RunTime:0.009487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56363959 ORDER BY `unit` DESC [ RunTime:0.023131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56363959 LIMIT 2 [ RunTime:0.018044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56363959 ORDER BY `minOrder` ASC [ RunTime:0.010150s ]
select * from pdf where partno='202K174-25-01-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.002711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202K174-25-01-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.013248s ]
SELECT `id` FROM `stock` WHERE `id` <> 56363959 AND `partno` = '202K174-25-01-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.014220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562509 [ RunTime:0.018357s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021588s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013387s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009471s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013531s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024258s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021045s ]
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 '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026484s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '202K174-25-0%' OR `brand` LIKE '202K174-25-0%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006759s ]