SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002461s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=A254&search=1' [ RunTime:0.002874s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002643s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000753s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002675s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002496s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001426s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002379s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002008s ]
SELECT * FROM `stock_search` WHERE `partno` = 'A254' LIMIT 1 [ RunTime:0.002176s ]
UPDATE `stock_search` SET `count` = 12 , `updatetime` = '2026-08-19 17:27:23' WHERE `partno` = 'A254' [ RunTime:0.003587s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002231s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007244s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513271 LIMIT 5 [ RunTime:0.005923s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513271 ORDER BY `minOrder` ASC [ RunTime:0.010881s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513271 ORDER BY `unit` DESC [ RunTime:0.007137s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513271 LIMIT 2 [ RunTime:0.021092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513271 ORDER BY `minOrder` ASC [ RunTime:0.010697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489900 LIMIT 5 [ RunTime:0.022730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489900 ORDER BY `minOrder` ASC [ RunTime:0.038707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15489900 ORDER BY `unit` DESC [ RunTime:0.042589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15489900 LIMIT 2 [ RunTime:0.017309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489900 ORDER BY `minOrder` ASC [ RunTime:0.004076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19828911 LIMIT 5 [ RunTime:0.015239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19828911 ORDER BY `minOrder` ASC [ RunTime:0.026087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19828911 ORDER BY `unit` DESC [ RunTime:0.006865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19828911 LIMIT 2 [ RunTime:0.020005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19828911 ORDER BY `minOrder` ASC [ RunTime:0.005079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13246391 LIMIT 5 [ RunTime:0.012639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13246391 ORDER BY `minOrder` ASC [ RunTime:0.008955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13246391 ORDER BY `unit` DESC [ RunTime:0.001458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13246391 LIMIT 2 [ RunTime:0.019316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13246391 ORDER BY `minOrder` ASC [ RunTime:0.003176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489782 LIMIT 5 [ RunTime:0.029246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489782 ORDER BY `minOrder` ASC [ RunTime:0.012245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15489782 ORDER BY `unit` DESC [ RunTime:0.021981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15489782 LIMIT 2 [ RunTime:0.026556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489782 ORDER BY `minOrder` ASC [ RunTime:0.008233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20126110 LIMIT 5 [ RunTime:0.009700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20126110 ORDER BY `minOrder` ASC [ RunTime:0.012985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20126110 ORDER BY `unit` DESC [ RunTime:0.004959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20126110 LIMIT 2 [ RunTime:0.009783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20126110 ORDER BY `minOrder` ASC [ RunTime:0.011929s ]
select * from pdf where partno='A2541WV-4P' and brandshort='CJT' limit 1 [ RunTime:0.010164s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-4P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.012900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20125826 LIMIT 5 [ RunTime:0.005394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20125826 ORDER BY `minOrder` ASC [ RunTime:0.002221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20125826 ORDER BY `unit` DESC [ RunTime:0.000318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20125826 LIMIT 2 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20125826 ORDER BY `minOrder` ASC [ RunTime:0.001057s ]
select * from pdf where partno='A2541WV-2P' and brandshort='CJT' limit 1 [ RunTime:0.000407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-2P' OR `brand` LIKE 'CJT(长江连接 器%' ) ) LIMIT 1 [ RunTime:0.000315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18902190 LIMIT 5 [ RunTime:0.001230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18902190 ORDER BY `minOrder` ASC [ RunTime:0.003458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18902190 ORDER BY `unit` DESC [ RunTime:0.010607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18902190 LIMIT 2 [ RunTime:0.001988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18902190 ORDER BY `minOrder` ASC [ RunTime:0.002671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13245884 LIMIT 5 [ RunTime:0.001724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13245884 ORDER BY `minOrder` ASC [ RunTime:0.003034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13245884 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13245884 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13245884 ORDER BY `minOrder` ASC [ RunTime:0.006439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12409935 LIMIT 5 [ RunTime:0.021140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12409935 ORDER BY `minOrder` ASC [ RunTime:0.013791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12409935 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12409935 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12409935 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975747 LIMIT 5 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975747 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11975747 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11975747 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975747 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006471s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60646571 LIMIT 5 [ RunTime:0.008874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60646571 ORDER BY `minOrder` ASC [ RunTime:0.003101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60646571 ORDER BY `unit` DESC [ RunTime:0.016272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60646571 LIMIT 2 [ RunTime:0.007319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60646571 ORDER BY `minOrder` ASC [ RunTime:0.001875s ]
select * from pdf where partno='A2543R' and brandshort='Elpress Inc.' limit 1 [ RunTime:0.000804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2543R' OR `brand` LIKE 'Elpress Inc.%' ) ) LIMIT 1 [ RunTime:0.021320s ]
SELECT `id` FROM `stock` WHERE `id` <> 60646571 AND `partno` = 'A2543R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%elpress inc.%' ) [ RunTime:0.005576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513271 [ RunTime:0.011581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59456570 LIMIT 5 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59456570 ORDER BY `minOrder` ASC [ RunTime:0.002956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59456570 ORDER BY `unit` DESC [ RunTime:0.006932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59456570 LIMIT 2 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59456570 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='A2542WV-03-N0WHT' and brandshort='Ease Electronics' limit 1 [ RunTime:0.002808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2542WV-03-N0WHT' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.004631s ]
SELECT `id` FROM `stock` WHERE `id` <> 59456570 AND `partno` = 'A2542WV-03-N0WHT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.004350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59471773 LIMIT 5 [ RunTime:0.000855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59471773 ORDER BY `minOrder` ASC [ RunTime:0.005585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59471773 ORDER BY `unit` DESC [ RunTime:0.012568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59471773 LIMIT 2 [ RunTime:0.004068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59471773 ORDER BY `minOrder` ASC [ RunTime:0.004683s ]
select * from pdf where partno='A2542WV-04-N0WHT' and brandshort='Ease Electronics' limit 1 [ RunTime:0.003251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2542WV-04-N0WHT' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.003149s ]
SELECT `id` FROM `stock` WHERE `id` <> 59471773 AND `partno` = 'A2542WV-04-N0WHT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.004672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59497673 LIMIT 5 [ RunTime:0.009922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59497673 ORDER BY `minOrder` ASC [ RunTime:0.017059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59497673 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59497673 LIMIT 2 [ RunTime:0.007440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59497673 ORDER BY `minOrder` ASC [ RunTime:0.010254s ]
select * from pdf where partno='A2544WVA-250-P0BKG' and brandshort='Ease Electronics' limit 1 [ RunTime:0.006250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2544WVA-250-P0BKG' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.003977s ]
SELECT `id` FROM `stock` WHERE `id` <> 59497673 AND `partno` = 'A2544WVA-250-P0BKG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.011030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489900 [ RunTime:0.005845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59496749 LIMIT 5 [ RunTime:0.004889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59496749 ORDER BY `minOrder` ASC [ RunTime:0.016465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59496749 ORDER BY `unit` DESC [ RunTime:0.028453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59496749 LIMIT 2 [ RunTime:0.011465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59496749 ORDER BY `minOrder` ASC [ RunTime:0.009880s ]
select * from pdf where partno='A2544WVA-216-P0BKG' and brandshort='Ease Electronics' limit 1 [ RunTime:0.012884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2544WVA-216-P0BKG' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.008038s ]
SELECT `id` FROM `stock` WHERE `id` <> 59496749 AND `partno` = 'A2544WVA-216-P0BKG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.004568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19828911 [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59505832 LIMIT 5 [ RunTime:0.003198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59505832 ORDER BY `minOrder` ASC [ RunTime:0.005812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59505832 ORDER BY `unit` DESC [ RunTime:0.009194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59505832 LIMIT 2 [ RunTime:0.004614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59505832 ORDER BY `minOrder` ASC [ RunTime:0.009744s ]
select * from pdf where partno='A2544WVA-240-P0BKG' and brandshort='Ease Electronics' limit 1 [ RunTime:0.004933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2544WVA-240-P0BKG' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.003400s ]
SELECT `id` FROM `stock` WHERE `id` <> 59505832 AND `partno` = 'A2544WVA-240-P0BKG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.006901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489782 [ RunTime:0.001116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64217998 LIMIT 5 [ RunTime:0.009741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64217998 ORDER BY `minOrder` ASC [ RunTime:0.005124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64217998 ORDER BY `unit` DESC [ RunTime:0.003189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64217998 LIMIT 2 [ RunTime:0.001098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64217998 ORDER BY `minOrder` ASC [ RunTime:0.001927s ]
select * from pdf where partno='A2541R24A10GM' and brandshort='TTM Technologies, Inc.' limit 1 [ RunTime:0.002465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541R24A10GM' OR `brand` LIKE 'TTM Technologies, Inc.%' ) ) LIMIT 1 [ RunTime:0.002848s ]
SELECT `id` FROM `stock` WHERE `id` <> 64217998 AND `partno` = 'A2541R24A10GM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ttm technologies, inc.%' ) [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13246391 [ RunTime:0.001692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63501247 LIMIT 5 [ RunTime:0.003463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63501247 ORDER BY `minOrder` ASC [ RunTime:0.003510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63501247 ORDER BY `unit` DESC [ RunTime:0.001339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63501247 LIMIT 2 [ RunTime:0.005416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63501247 ORDER BY `minOrder` ASC [ RunTime:0.004331s ]
select * from pdf where partno='A254' and brandshort='TPI Test Products Int' limit 1 [ RunTime:0.001335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A254' OR `brand` LIKE 'TPI (Test Products Int)%' ) ) LIMIT 1 [ RunTime:0.000562s ]
SELECT `id` FROM `stock` WHERE `id` <> 63501247 AND `partno` = 'A254' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tpi%' ) [ RunTime:0.006163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18902190 [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59632262 LIMIT 5 [ RunTime:0.001285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59632262 ORDER BY `minOrder` ASC [ RunTime:0.012910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59632262 ORDER BY `unit` DESC [ RunTime:0.003005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59632262 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59632262 ORDER BY `minOrder` ASC [ RunTime:0.002235s ]
select * from pdf where partno='A2544WVA-240-P0BKGB' and brandshort='Ease Electronics' limit 1 [ RunTime:0.001676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2544WVA-240-P0BKGB' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.009285s ]
SELECT `id` FROM `stock` WHERE `id` <> 59632262 AND `partno` = 'A2544WVA-240-P0BKGB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.002901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59620231 LIMIT 5 [ RunTime:0.007353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59620231 ORDER BY `minOrder` ASC [ RunTime:0.005195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59620231 ORDER BY `unit` DESC [ RunTime:0.008728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59620231 LIMIT 2 [ RunTime:0.011864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59620231 ORDER BY `minOrder` ASC [ RunTime:0.005942s ]
select * from pdf where partno='A2544WVA-226-P0BKGB' and brandshort='Ease Electronics' limit 1 [ RunTime:0.002576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2544WVA-226-P0BKGB' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.007006s ]
SELECT `id` FROM `stock` WHERE `id` <> 59620231 AND `partno` = 'A2544WVA-226-P0BKGB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.009887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59611603 LIMIT 5 [ RunTime:0.002919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59611603 ORDER BY `minOrder` ASC [ RunTime:0.005769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59611603 ORDER BY `unit` DESC [ RunTime:0.010513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59611603 LIMIT 2 [ RunTime:0.005437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59611603 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='A2544WRA-214-P0BKG' and brandshort='Ease Electronics' limit 1 [ RunTime:0.000994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2544WRA-214-P0BKG' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.000590s ]
SELECT `id` FROM `stock` WHERE `id` <> 59611603 AND `partno` = 'A2544WRA-214-P0BKG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.001004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59606023 LIMIT 5 [ RunTime:0.009140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59606023 ORDER BY `minOrder` ASC [ RunTime:0.012835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59606023 ORDER BY `unit` DESC [ RunTime:0.000915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59606023 LIMIT 2 [ RunTime:0.003831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59606023 ORDER BY `minOrder` ASC [ RunTime:0.004984s ]
select * from pdf where partno='A2544WRA-210-P0BKG' and brandshort='Ease Electronics' limit 1 [ RunTime:0.006355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2544WRA-210-P0BKG' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.000966s ]
SELECT `id` FROM `stock` WHERE `id` <> 59606023 AND `partno` = 'A2544WRA-210-P0BKG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.003423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59606022 LIMIT 5 [ RunTime:0.004097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59606022 ORDER BY `minOrder` ASC [ RunTime:0.003404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59606022 ORDER BY `unit` DESC [ RunTime:0.007894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59606022 LIMIT 2 [ RunTime:0.011144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59606022 ORDER BY `minOrder` ASC [ RunTime:0.001999s ]
select * from pdf where partno='A2544WVA-210-P0BKG' and brandshort='Ease Electronics' limit 1 [ RunTime:0.002807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2544WVA-210-P0BKG' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.003214s ]
SELECT `id` FROM `stock` WHERE `id` <> 59606022 AND `partno` = 'A2544WVA-210-P0BKG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.004596s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010006s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002520s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007131s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002158s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000848s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006709s ]
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 'A254%' OR `brand` LIKE 'A254%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019082 LIMIT 5 [ RunTime:0.004813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019082 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019082 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019082 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019082 ORDER BY `minOrder` ASC [ RunTime:0.000896s ]
select * from pdf where partno='A2547-TP' and brandshort='CJT' limit 1 [ RunTime:0.003119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2547-TP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.001275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51014741 LIMIT 5 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014741 ORDER BY `minOrder` ASC [ RunTime:0.000961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51014741 ORDER BY `unit` DESC [ RunTime:0.000427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51014741 LIMIT 2 [ RunTime:0.002733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014741 ORDER BY `minOrder` ASC [ RunTime:0.009644s ]
select * from pdf where partno='A2547-GP' and brandshort='CJT' limit 1 [ RunTime:0.001387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2547-GP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.001803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018935 LIMIT 5 [ RunTime:0.008857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018935 ORDER BY `minOrder` ASC [ RunTime:0.005368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018935 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018935 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018935 ORDER BY `minOrder` ASC [ RunTime:0.000219s ]
select * from pdf where partno='A2541WV-3P' and brandshort='CJT' limit 1 [ RunTime:0.000550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-3P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.015952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018912 LIMIT 5 [ RunTime:0.004133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018912 ORDER BY `minOrder` ASC [ RunTime:0.001364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018912 ORDER BY `unit` DESC [ RunTime:0.000314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018912 LIMIT 2 [ RunTime:0.002616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018912 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
select * from pdf where partno='A2541WV-2P' and brandshort='CJT' limit 1 [ RunTime:0.002366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-2P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.000568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019631 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019631 ORDER BY `minOrder` ASC [ RunTime:0.003591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019631 ORDER BY `unit` DESC [ RunTime:0.011367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019631 LIMIT 2 [ RunTime:0.013981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019631 ORDER BY `minOrder` ASC [ RunTime:0.004462s ]
select * from pdf where partno='A254UP-ZD04P' and brandshort='BXCONN' limit 1 [ RunTime:0.010318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A254UP-ZD04P' OR `brand` LIKE 'BXCONN(宝讯)%' ) ) LIMIT 1 [ RunTime:0.010057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32115420 LIMIT 5 [ RunTime:0.003954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32115420 ORDER BY `minOrder` ASC [ RunTime:0.009292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32115420 ORDER BY `unit` DESC [ RunTime:0.001369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32115420 LIMIT 2 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32115420 ORDER BY `minOrder` ASC [ RunTime:0.000215s ]
select * from pdf where partno='A2541WV-5P' and brandshort='CJT' limit 1 [ RunTime:0.003338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-5P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32130978 LIMIT 5 [ RunTime:0.002953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32130978 ORDER BY `minOrder` ASC [ RunTime:0.008602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32130978 ORDER BY `unit` DESC [ RunTime:0.001143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32130978 LIMIT 2 [ RunTime:0.000259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32130978 ORDER BY `minOrder` ASC [ RunTime:0.002877s ]
select * from pdf where partno='A2541WV-5P' and brandshort='CJT' limit 1 [ RunTime:0.006217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-5P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.000254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019174 LIMIT 5 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019174 ORDER BY `minOrder` ASC [ RunTime:0.005115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019174 ORDER BY `unit` DESC [ RunTime:0.013825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019174 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019174 ORDER BY `minOrder` ASC [ RunTime:0.003262s ]
select * from pdf where partno='A2541WV-4P' and brandshort='CJT' limit 1 [ RunTime:0.006100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-4P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.005112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51014714 LIMIT 5 [ RunTime:0.004957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014714 ORDER BY `minOrder` ASC [ RunTime:0.008410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51014714 ORDER BY `unit` DESC [ RunTime:0.001417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51014714 LIMIT 2 [ RunTime:0.006052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014714 ORDER BY `minOrder` ASC [ RunTime:0.001528s ]
select * from pdf where partno='A254UP-ZS03P' and brandshort='BXCONN' limit 1 [ RunTime:0.005015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A254UP-ZS03P' OR `brand` LIKE 'BXCONN(宝讯)%' ) ) LIMIT 1 [ RunTime:0.000787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44120716 LIMIT 5 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44120716 ORDER BY `minOrder` ASC [ RunTime:0.008287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44120716 ORDER BY `unit` DESC [ RunTime:0.003631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44120716 LIMIT 2 [ RunTime:0.012319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44120716 ORDER BY `minOrder` ASC [ RunTime:0.004494s ]
select * from pdf where partno='A2541WV-2x5P' and brandshort='CJT' limit 1 [ RunTime:0.004793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-2x5P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.003755s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A254%' OR `brand` LIKE 'A254%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009670s ]