SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001471s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.48' , `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=6402&search=1' [ RunTime:0.002712s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001192s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001714s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001720s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.48' ) [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001242s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000275s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001066s ]
SELECT * FROM `stock_search` WHERE `partno` = '6402' LIMIT 1 [ RunTime:0.006207s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-30 15:24:02' WHERE `partno` = '6402' [ RunTime:0.017371s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001552s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017735s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612748 LIMIT 5 [ RunTime:0.004028s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612748 ORDER BY `minOrder` ASC [ RunTime:0.000906s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612748 ORDER BY `unit` DESC [ RunTime:0.006091s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612748 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612748 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513886 LIMIT 5 [ RunTime:0.003329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513886 ORDER BY `minOrder` ASC [ RunTime:0.000979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513886 ORDER BY `unit` DESC [ RunTime:0.003011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513886 LIMIT 2 [ RunTime:0.001895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513886 ORDER BY `minOrder` ASC [ RunTime:0.001278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589039 LIMIT 5 [ RunTime:0.001853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589039 ORDER BY `minOrder` ASC [ RunTime:0.008335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19589039 ORDER BY `unit` DESC [ RunTime:0.000568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19589039 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589039 ORDER BY `minOrder` ASC [ RunTime:0.002084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487600 LIMIT 5 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487600 ORDER BY `minOrder` ASC [ RunTime:0.004926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487600 ORDER BY `unit` DESC [ RunTime:0.001491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487600 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487600 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495715 LIMIT 5 [ RunTime:0.000953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495715 ORDER BY `minOrder` ASC [ RunTime:0.009418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495715 ORDER BY `unit` DESC [ RunTime:0.004289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495715 LIMIT 2 [ RunTime:0.009294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495715 ORDER BY `minOrder` ASC [ RunTime:0.001622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488320 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488320 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11488320 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11488320 LIMIT 2 [ RunTime:0.001396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488320 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494997 LIMIT 5 [ RunTime:0.001310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494997 ORDER BY `minOrder` ASC [ RunTime:0.003419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494997 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494997 LIMIT 2 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494997 ORDER BY `minOrder` ASC [ RunTime:0.003039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618408 LIMIT 5 [ RunTime:0.002117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618408 ORDER BY `minOrder` ASC [ RunTime:0.004458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618408 ORDER BY `unit` DESC [ RunTime:0.000884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618408 LIMIT 2 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618408 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484088 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484088 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484088 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484088 LIMIT 2 [ RunTime:0.005377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484088 ORDER BY `minOrder` ASC [ RunTime:0.003866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621668 LIMIT 5 [ RunTime:0.003449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621668 ORDER BY `minOrder` ASC [ RunTime:0.007213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12621668 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12621668 LIMIT 2 [ RunTime:0.003222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621668 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496124 LIMIT 5 [ RunTime:0.005577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496124 ORDER BY `minOrder` ASC [ RunTime:0.008967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496124 ORDER BY `unit` DESC [ RunTime:0.000745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496124 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496124 ORDER BY `minOrder` ASC [ RunTime:0.001181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617552 LIMIT 5 [ RunTime:0.009287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617552 ORDER BY `minOrder` ASC [ RunTime:0.020761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12617552 ORDER BY `unit` DESC [ RunTime:0.005174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12617552 LIMIT 2 [ RunTime:0.006222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617552 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494946 LIMIT 5 [ RunTime:0.004691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494946 ORDER BY `minOrder` ASC [ RunTime:0.001726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494946 ORDER BY `unit` DESC [ RunTime:0.000683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494946 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494946 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629146 LIMIT 5 [ RunTime:0.001132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629146 ORDER BY `minOrder` ASC [ RunTime:0.002660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629146 ORDER BY `unit` DESC [ RunTime:0.008438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629146 LIMIT 2 [ RunTime:0.000831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629146 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2762 LIMIT 5 [ RunTime:0.003891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2762 ORDER BY `minOrder` ASC [ RunTime:0.001292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2762 ORDER BY `unit` DESC [ RunTime:0.007148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2762 LIMIT 2 [ RunTime:0.004127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2762 ORDER BY `minOrder` ASC [ RunTime:0.003511s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640250-6' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.006850s ]
SELECT `id` FROM `stock` WHERE `id` <> 2762 AND `partno` = '640250-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.001024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488725 LIMIT 5 [ RunTime:0.006273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488725 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11488725 ORDER BY `unit` DESC [ RunTime:0.007962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11488725 LIMIT 2 [ RunTime:0.000717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488725 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13418 LIMIT 5 [ RunTime:0.006449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13418 ORDER BY `minOrder` ASC [ RunTime:0.015041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13418 ORDER BY `unit` DESC [ RunTime:0.012697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13418 LIMIT 2 [ RunTime:0.005570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13418 ORDER BY `minOrder` ASC [ RunTime:0.009220s ]
select * from pdf where partno='640254-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.005842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640254-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.013801s ]
SELECT `id` FROM `stock` WHERE `id` <> 13418 AND `partno` = '640254-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.004149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513004 LIMIT 5 [ RunTime:0.001468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513004 ORDER BY `minOrder` ASC [ RunTime:0.014680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513004 ORDER BY `unit` DESC [ RunTime:0.000729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513004 LIMIT 2 [ RunTime:0.004071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513004 ORDER BY `minOrder` ASC [ RunTime:0.006129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613299 LIMIT 5 [ RunTime:0.012147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613299 ORDER BY `minOrder` ASC [ RunTime:0.005660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613299 ORDER BY `unit` DESC [ RunTime:0.002328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613299 LIMIT 2 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613299 ORDER BY `minOrder` ASC [ RunTime:0.004429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489494 LIMIT 5 [ RunTime:0.006260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489494 ORDER BY `minOrder` ASC [ RunTime:0.006056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11489494 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11489494 LIMIT 2 [ RunTime:0.011181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489494 ORDER BY `minOrder` ASC [ RunTime:0.008761s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282395 LIMIT 5 [ RunTime:0.003391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282395 ORDER BY `minOrder` ASC [ RunTime:0.001178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282395 ORDER BY `unit` DESC [ RunTime:0.002282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282395 LIMIT 2 [ RunTime:0.005966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282395 ORDER BY `minOrder` ASC [ RunTime:0.002578s ]
select * from pdf where partno='640204-1' and brandshort='te connectivity' limit 1 [ RunTime:0.006266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640204-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.027944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32221319 LIMIT 5 [ RunTime:0.007064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221319 ORDER BY `minOrder` ASC [ RunTime:0.010572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32221319 ORDER BY `unit` DESC [ RunTime:0.008548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32221319 LIMIT 2 [ RunTime:0.004284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221319 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
select * from pdf where partno='64025-510-000 cm5-200 black kit' and brandshort='pactec' limit 1 [ RunTime:0.007225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64025-510-000 cm5-200 black kit' OR `brand` LIKE 'pactec%' ) ) LIMIT 1 [ RunTime:0.007197s ]
SELECT `id` FROM `stock` WHERE `id` <> 32221319 AND `partno` = '64025-510-000 cm5-200 black kit' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pactec%' ) [ RunTime:0.002673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51110565 LIMIT 5 [ RunTime:0.005352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51110565 ORDER BY `minOrder` ASC [ RunTime:0.002148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51110565 ORDER BY `unit` DESC [ RunTime:0.002026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51110565 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51110565 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='64029' and brandshort='parallax' limit 1 [ RunTime:0.000968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64029' OR `brand` LIKE 'parallax%' ) ) LIMIT 1 [ RunTime:0.006966s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60643612 LIMIT 5 [ RunTime:0.003449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643612 ORDER BY `minOrder` ASC [ RunTime:0.014048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60643612 ORDER BY `unit` DESC [ RunTime:0.004006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60643612 LIMIT 2 [ RunTime:0.005801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643612 ORDER BY `minOrder` ASC [ RunTime:0.004392s ]
select * from pdf where partno='640259-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640259-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002643s ]
SELECT `id` FROM `stock` WHERE `id` <> 60643612 AND `partno` = '640259-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589039 [ RunTime:0.019057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644267 LIMIT 5 [ RunTime:0.010521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644267 ORDER BY `minOrder` ASC [ RunTime:0.007339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644267 ORDER BY `unit` DESC [ RunTime:0.004204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644267 LIMIT 2 [ RunTime:0.003653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644267 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='640253-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640253-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007598s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644267 AND `partno` = '640253-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935162 LIMIT 5 [ RunTime:0.003252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935162 ORDER BY `minOrder` ASC [ RunTime:0.006563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935162 ORDER BY `unit` DESC [ RunTime:0.003467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935162 LIMIT 2 [ RunTime:0.002511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935162 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='640250-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640250-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000761s ]
SELECT `id` FROM `stock` WHERE `id` <> 59935162 AND `partno` = '640250-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935494 LIMIT 5 [ RunTime:0.005277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935494 ORDER BY `minOrder` ASC [ RunTime:0.007535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935494 ORDER BY `unit` DESC [ RunTime:0.004931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935494 LIMIT 2 [ RunTime:0.003473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935494 ORDER BY `minOrder` ASC [ RunTime:0.007648s ]
select * from pdf where partno='640250-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640250-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59940908 LIMIT 5 [ RunTime:0.007983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59940908 ORDER BY `minOrder` ASC [ RunTime:0.002443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59940908 ORDER BY `unit` DESC [ RunTime:0.006535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59940908 LIMIT 2 [ RunTime:0.004798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59940908 ORDER BY `minOrder` ASC [ RunTime:0.004046s ]
select * from pdf where partno='640251-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640251-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001412s ]
SELECT `id` FROM `stock` WHERE `id` <> 59940908 AND `partno` = '640251-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495715 [ RunTime:0.004785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935077 LIMIT 5 [ RunTime:0.003589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935077 ORDER BY `minOrder` ASC [ RunTime:0.003345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935077 ORDER BY `unit` DESC [ RunTime:0.001938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935077 LIMIT 2 [ RunTime:0.006236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935077 ORDER BY `minOrder` ASC [ RunTime:0.005033s ]
select * from pdf where partno='640250-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640250-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024025s ]
SELECT `id` FROM `stock` WHERE `id` <> 59935077 AND `partno` = '640250-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.053109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936144 LIMIT 5 [ RunTime:0.047322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936144 ORDER BY `minOrder` ASC [ RunTime:0.015090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936144 ORDER BY `unit` DESC [ RunTime:0.041447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936144 LIMIT 2 [ RunTime:0.042910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936144 ORDER BY `minOrder` ASC [ RunTime:0.013442s ]
select * from pdf where partno='640250-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640250-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.070232s ]
SELECT `id` FROM `stock` WHERE `id` <> 59936144 AND `partno` = '640250-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629380 [ RunTime:0.035214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934997 LIMIT 5 [ RunTime:0.027168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934997 ORDER BY `minOrder` ASC [ RunTime:0.056876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934997 ORDER BY `unit` DESC [ RunTime:0.013764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934997 LIMIT 2 [ RunTime:0.020254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934997 ORDER BY `minOrder` ASC [ RunTime:0.006119s ]
select * from pdf where partno='640251-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640251-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008310s ]
SELECT `id` FROM `stock` WHERE `id` <> 59934997 AND `partno` = '640251-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.050422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936060 LIMIT 5 [ RunTime:0.025606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936060 ORDER BY `minOrder` ASC [ RunTime:0.014016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936060 ORDER BY `unit` DESC [ RunTime:0.009758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936060 LIMIT 2 [ RunTime:0.005637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936060 ORDER BY `minOrder` ASC [ RunTime:0.001072s ]
select * from pdf where partno='640250-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640250-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002937s ]
SELECT `id` FROM `stock` WHERE `id` <> 59936060 AND `partno` = '640250-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621668 [ RunTime:0.009337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644277 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644277 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644277 ORDER BY `unit` DESC [ RunTime:0.005529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644277 LIMIT 2 [ RunTime:0.003769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644277 ORDER BY `minOrder` ASC [ RunTime:0.001567s ]
select * from pdf where partno='640204-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640204-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009584s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644277 AND `partno` = '640204-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938737 LIMIT 5 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938737 ORDER BY `minOrder` ASC [ RunTime:0.021688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938737 ORDER BY `unit` DESC [ RunTime:0.005088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938737 LIMIT 2 [ RunTime:0.007085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938737 ORDER BY `minOrder` ASC [ RunTime:0.001902s ]
select * from pdf where partno='640251-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640251-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001012s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938737 AND `partno` = '640251-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494997 [ RunTime:0.005122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938807 LIMIT 5 [ RunTime:0.014144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938807 ORDER BY `minOrder` ASC [ RunTime:0.016818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938807 ORDER BY `unit` DESC [ RunTime:0.029736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938807 LIMIT 2 [ RunTime:0.015486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938807 ORDER BY `minOrder` ASC [ RunTime:0.002321s ]
select * from pdf where partno='640251-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640251-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001034s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938807 AND `partno` = '640251-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617840 [ RunTime:0.034029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938655 LIMIT 5 [ RunTime:0.025614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938655 ORDER BY `minOrder` ASC [ RunTime:0.016816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938655 ORDER BY `unit` DESC [ RunTime:0.003299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938655 LIMIT 2 [ RunTime:0.011868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938655 ORDER BY `minOrder` ASC [ RunTime:0.001829s ]
select * from pdf where partno='640251-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640251-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011946s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938655 AND `partno` = '640251-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618408 [ RunTime:0.010289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935671 LIMIT 5 [ RunTime:0.002208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935671 ORDER BY `minOrder` ASC [ RunTime:0.007827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935671 ORDER BY `unit` DESC [ RunTime:0.014978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935671 LIMIT 2 [ RunTime:0.007061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935671 ORDER BY `minOrder` ASC [ RunTime:0.003953s ]
select * from pdf where partno='640250-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640250-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006205s ]
SELECT `id` FROM `stock` WHERE `id` <> 59935671 AND `partno` = '640250-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488725 [ RunTime:0.004792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938553 LIMIT 5 [ RunTime:0.013781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938553 ORDER BY `minOrder` ASC [ RunTime:0.013359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938553 ORDER BY `unit` DESC [ RunTime:0.000534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938553 LIMIT 2 [ RunTime:0.010016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938553 ORDER BY `minOrder` ASC [ RunTime:0.002169s ]
select * from pdf where partno='640251-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640251-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009690s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938553 AND `partno` = '640251-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362098 LIMIT 5 [ RunTime:0.018317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362098 ORDER BY `minOrder` ASC [ RunTime:0.002836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362098 ORDER BY `unit` DESC [ RunTime:0.000922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362098 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362098 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
select * from pdf where partno='640254-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640254-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002647s ]
SELECT `id` FROM `stock` WHERE `id` <> 60362098 AND `partno` = '640254-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484088 [ RunTime:0.010508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938576 LIMIT 5 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938576 ORDER BY `minOrder` ASC [ RunTime:0.000747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938576 ORDER BY `unit` DESC [ RunTime:0.005967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938576 LIMIT 2 [ RunTime:0.003273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938576 ORDER BY `minOrder` ASC [ RunTime:0.001138s ]
select * from pdf where partno='640251-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640251-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001129s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938576 AND `partno` = '640251-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494946 [ RunTime:0.012379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938645 LIMIT 5 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938645 ORDER BY `minOrder` ASC [ RunTime:0.002784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938645 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938645 LIMIT 2 [ RunTime:0.007145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938645 ORDER BY `minOrder` ASC [ RunTime:0.005915s ]
select * from pdf where partno='640251-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640251-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001809s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938645 AND `partno` = '640251-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629146 [ RunTime:0.002614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001344 LIMIT 5 [ RunTime:0.001284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001344 ORDER BY `minOrder` ASC [ RunTime:0.001234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001344 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001344 LIMIT 2 [ RunTime:0.003076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001344 ORDER BY `minOrder` ASC [ RunTime:0.002289s ]
select * from pdf where partno='6402FE 8771000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6402FE 8771000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.001072s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001344 AND `partno` = '6402FE 8771000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495611 [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60645969 LIMIT 5 [ RunTime:0.003922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60645969 ORDER BY `minOrder` ASC [ RunTime:0.004376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60645969 ORDER BY `unit` DESC [ RunTime:0.000741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60645969 LIMIT 2 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60645969 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='640212-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640212-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000766s ]
SELECT `id` FROM `stock` WHERE `id` <> 60645969 AND `partno` = '640212-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513004 [ RunTime:0.000816s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009036s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002640s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001941s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001252s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005601s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005519s ]
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 '6402%' OR `brand` LIKE '6402%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001393s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6402%' OR `brand` LIKE '6402%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028005s ]