SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001581s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.149' , `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=23640&search=1' [ RunTime:0.011035s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.009945s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010170s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.006582s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.149' ) [ RunTime:0.004490s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.007401s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001609s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002839s ]
SELECT * FROM `stock_search` WHERE `partno` = '23640' LIMIT 1 [ RunTime:0.001277s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-09-08 07:18:45' WHERE `partno` = '23640' [ RunTime:0.005175s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.005948s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006382s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613313 LIMIT 5 [ RunTime:0.006254s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613313 ORDER BY `minOrder` ASC [ RunTime:0.001105s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613313 ORDER BY `unit` DESC [ RunTime:0.000892s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613313 LIMIT 2 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613313 ORDER BY `minOrder` ASC [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484048 LIMIT 5 [ RunTime:0.016107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484048 ORDER BY `minOrder` ASC [ RunTime:0.009880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484048 ORDER BY `unit` DESC [ RunTime:0.011097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484048 LIMIT 2 [ RunTime:0.011072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484048 ORDER BY `minOrder` ASC [ RunTime:0.011000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16237775 LIMIT 5 [ RunTime:0.008856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16237775 ORDER BY `minOrder` ASC [ RunTime:0.001874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16237775 ORDER BY `unit` DESC [ RunTime:0.010110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16237775 LIMIT 2 [ RunTime:0.007177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16237775 ORDER BY `minOrder` ASC [ RunTime:0.011171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494627 LIMIT 5 [ RunTime:0.011119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494627 ORDER BY `minOrder` ASC [ RunTime:0.015005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15494627 ORDER BY `unit` DESC [ RunTime:0.000880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15494627 LIMIT 2 [ RunTime:0.000866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494627 ORDER BY `minOrder` ASC [ RunTime:0.000899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764620 LIMIT 5 [ RunTime:0.005468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764620 ORDER BY `minOrder` ASC [ RunTime:0.000952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19764620 ORDER BY `unit` DESC [ RunTime:0.000740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19764620 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764620 ORDER BY `minOrder` ASC [ RunTime:0.000837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18994968 LIMIT 5 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18994968 ORDER BY `minOrder` ASC [ RunTime:0.000862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18994968 ORDER BY `unit` DESC [ RunTime:0.000799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18994968 LIMIT 2 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18994968 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431216 LIMIT 5 [ RunTime:0.006847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431216 ORDER BY `minOrder` ASC [ RunTime:0.012888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431216 ORDER BY `unit` DESC [ RunTime:0.004139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431216 LIMIT 2 [ RunTime:0.000783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431216 ORDER BY `minOrder` ASC [ RunTime:0.002487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459372 LIMIT 5 [ RunTime:0.003847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459372 ORDER BY `minOrder` ASC [ RunTime:0.005662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459372 ORDER BY `unit` DESC [ RunTime:0.001233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459372 LIMIT 2 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459372 ORDER BY `minOrder` ASC [ RunTime:0.005486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13169482 LIMIT 5 [ RunTime:0.011013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169482 ORDER BY `minOrder` ASC [ RunTime:0.005923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13169482 ORDER BY `unit` DESC [ RunTime:0.000927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13169482 LIMIT 2 [ RunTime:0.000811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169482 ORDER BY `minOrder` ASC [ RunTime:0.005929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13166910 LIMIT 5 [ RunTime:0.006042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13166910 ORDER BY `minOrder` ASC [ RunTime:0.000902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13166910 ORDER BY `unit` DESC [ RunTime:0.002195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13166910 LIMIT 2 [ RunTime:0.003340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13166910 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13112819 LIMIT 5 [ RunTime:0.009756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13112819 ORDER BY `minOrder` ASC [ RunTime:0.001700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13112819 ORDER BY `unit` DESC [ RunTime:0.001798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13112819 LIMIT 2 [ RunTime:0.001462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13112819 ORDER BY `minOrder` ASC [ RunTime:0.001220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618115 LIMIT 5 [ RunTime:0.002432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618115 ORDER BY `minOrder` ASC [ RunTime:0.001330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618115 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618115 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618115 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618094 LIMIT 5 [ RunTime:0.002553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618094 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618094 ORDER BY `unit` DESC [ RunTime:0.001619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618094 LIMIT 2 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618094 ORDER BY `minOrder` ASC [ RunTime:0.000884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611754 LIMIT 5 [ RunTime:0.001460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611754 ORDER BY `minOrder` ASC [ RunTime:0.001338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611754 ORDER BY `unit` DESC [ RunTime:0.000863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611754 LIMIT 2 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611754 ORDER BY `minOrder` ASC [ RunTime:0.000877s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002600s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67748634 LIMIT 5 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67748634 ORDER BY `minOrder` ASC [ RunTime:0.005618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67748634 ORDER BY `unit` DESC [ RunTime:0.000855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67748634 LIMIT 2 [ RunTime:0.001167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67748634 ORDER BY `minOrder` ASC [ RunTime:0.001141s ]
select * from pdf where partno='2364030-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013163s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364030-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004908s ]
SELECT `id` FROM `stock` WHERE `id` <> 67748634 AND `partno` = '2364030-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13166910 [ RunTime:0.001979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70233122 LIMIT 5 [ RunTime:0.002166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70233122 ORDER BY `minOrder` ASC [ RunTime:0.005692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70233122 ORDER BY `unit` DESC [ RunTime:0.000953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70233122 LIMIT 2 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70233122 ORDER BY `minOrder` ASC [ RunTime:0.000957s ]
select * from pdf where partno='2364000' and brandshort='Rittal' limit 1 [ RunTime:0.001288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364000' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.001646s ]
SELECT `id` FROM `stock` WHERE `id` <> 70233122 AND `partno` = '2364000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.001445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18994968 [ RunTime:0.000889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69938335 LIMIT 5 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69938335 ORDER BY `minOrder` ASC [ RunTime:0.002741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69938335 ORDER BY `unit` DESC [ RunTime:0.000940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69938335 LIMIT 2 [ RunTime:0.000828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69938335 ORDER BY `minOrder` ASC [ RunTime:0.000982s ]
select * from pdf where partno='23640.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.001328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23640.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.001505s ]
SELECT `id` FROM `stock` WHERE `id` <> 69938335 AND `partno` = '23640.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.001556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431216 [ RunTime:0.000954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67763693 LIMIT 5 [ RunTime:0.001373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67763693 ORDER BY `minOrder` ASC [ RunTime:0.003162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67763693 ORDER BY `unit` DESC [ RunTime:0.000884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67763693 LIMIT 2 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67763693 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
select * from pdf where partno='2364030-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364030-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001157s ]
SELECT `id` FROM `stock` WHERE `id` <> 67763693 AND `partno` = '2364030-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13169482 [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67177170 LIMIT 5 [ RunTime:0.000942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67177170 ORDER BY `minOrder` ASC [ RunTime:0.006950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67177170 ORDER BY `unit` DESC [ RunTime:0.001085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67177170 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67177170 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
select * from pdf where partno='2364004-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364004-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001198s ]
SELECT `id` FROM `stock` WHERE `id` <> 67177170 AND `partno` = '2364004-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613313 [ RunTime:0.000922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67176244 LIMIT 5 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67176244 ORDER BY `minOrder` ASC [ RunTime:0.002155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67176244 ORDER BY `unit` DESC [ RunTime:0.000883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67176244 LIMIT 2 [ RunTime:0.003446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67176244 ORDER BY `minOrder` ASC [ RunTime:0.000910s ]
select * from pdf where partno='2364004-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364004-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001341s ]
SELECT `id` FROM `stock` WHERE `id` <> 67176244 AND `partno` = '2364004-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67176243 LIMIT 5 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67176243 ORDER BY `minOrder` ASC [ RunTime:0.001490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67176243 ORDER BY `unit` DESC [ RunTime:0.000842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67176243 LIMIT 2 [ RunTime:0.000884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67176243 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
select * from pdf where partno='2364004-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364004-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001131s ]
SELECT `id` FROM `stock` WHERE `id` <> 67176243 AND `partno` = '2364004-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484048 [ RunTime:0.000966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67160246 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67160246 ORDER BY `minOrder` ASC [ RunTime:0.015506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67160246 ORDER BY `unit` DESC [ RunTime:0.001326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67160246 LIMIT 2 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67160246 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
select * from pdf where partno='2364003-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364003-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001444s ]
SELECT `id` FROM `stock` WHERE `id` <> 67160246 AND `partno` = '2364003-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611754 [ RunTime:0.000952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66763653 LIMIT 5 [ RunTime:0.000915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66763653 ORDER BY `minOrder` ASC [ RunTime:0.001515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66763653 ORDER BY `unit` DESC [ RunTime:0.001373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66763653 LIMIT 2 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66763653 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
select * from pdf where partno='2364000-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364000-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000754s ]
SELECT `id` FROM `stock` WHERE `id` <> 66763653 AND `partno` = '2364000-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66762583 LIMIT 5 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66762583 ORDER BY `minOrder` ASC [ RunTime:0.001399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66762583 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66762583 LIMIT 2 [ RunTime:0.005425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66762583 ORDER BY `minOrder` ASC [ RunTime:0.000752s ]
select * from pdf where partno='2364000-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364000-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000681s ]
SELECT `id` FROM `stock` WHERE `id` <> 66762583 AND `partno` = '2364000-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618115 [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66761505 LIMIT 5 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66761505 ORDER BY `minOrder` ASC [ RunTime:0.003891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66761505 ORDER BY `unit` DESC [ RunTime:0.000688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66761505 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66761505 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='2364000-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364000-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000530s ]
SELECT `id` FROM `stock` WHERE `id` <> 66761505 AND `partno` = '2364000-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618094 [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66410604 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66410604 ORDER BY `minOrder` ASC [ RunTime:0.000763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66410604 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66410604 LIMIT 2 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66410604 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='2364002-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364002-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000543s ]
SELECT `id` FROM `stock` WHERE `id` <> 66410604 AND `partno` = '2364002-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764620 [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66408214 LIMIT 5 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66408214 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66408214 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66408214 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66408214 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='2364002-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364002-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000512s ]
SELECT `id` FROM `stock` WHERE `id` <> 66408214 AND `partno` = '2364002-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494627 [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66356423 LIMIT 5 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66356423 ORDER BY `minOrder` ASC [ RunTime:0.002068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66356423 ORDER BY `unit` DESC [ RunTime:0.000470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66356423 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66356423 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='2364002-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364002-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000593s ]
SELECT `id` FROM `stock` WHERE `id` <> 66356423 AND `partno` = '2364002-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16237775 [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65541445 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65541445 ORDER BY `minOrder` ASC [ RunTime:0.005913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65541445 ORDER BY `unit` DESC [ RunTime:0.001025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65541445 LIMIT 2 [ RunTime:0.001095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65541445 ORDER BY `minOrder` ASC [ RunTime:0.001020s ]
select * from pdf where partno='2364031-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.006104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2364031-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.001489s ]
SELECT `id` FROM `stock` WHERE `id` <> 65541445 AND `partno` = '2364031-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.001667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13112819 [ RunTime:0.001763s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002037s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002009s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001980s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001801s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001715s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001973s ]
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 '23640%' OR `brand` LIKE '23640%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002230s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '23640%' OR `brand` LIKE '23640%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002651s ]