SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001792s ]
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=5417&search=1' [ RunTime:0.038629s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001525s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016124s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001604s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.006246s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001249s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004393s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001292s ]
SELECT * FROM `stock_search` WHERE `partno` = '5417' LIMIT 1 [ RunTime:0.035281s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-25 15:51:56' WHERE `partno` = '5417' [ RunTime:0.058966s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002607s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057439s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19176053 LIMIT 5 [ RunTime:0.048736s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.034103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19176053 ORDER BY `minOrder` ASC [ RunTime:0.057687s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.065358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19176053 ORDER BY `unit` DESC [ RunTime:0.106526s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19176053 LIMIT 2 [ RunTime:0.048453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19176053 ORDER BY `minOrder` ASC [ RunTime:0.098011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344075 LIMIT 5 [ RunTime:0.068874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344075 ORDER BY `minOrder` ASC [ RunTime:0.065229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13344075 ORDER BY `unit` DESC [ RunTime:0.258437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13344075 LIMIT 2 [ RunTime:0.087547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344075 ORDER BY `minOrder` ASC [ RunTime:0.062762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17110975 LIMIT 5 [ RunTime:0.062210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17110975 ORDER BY `minOrder` ASC [ RunTime:0.099976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17110975 ORDER BY `unit` DESC [ RunTime:0.031012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17110975 LIMIT 2 [ RunTime:0.032755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17110975 ORDER BY `minOrder` ASC [ RunTime:0.067257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19176049 LIMIT 5 [ RunTime:0.090285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19176049 ORDER BY `minOrder` ASC [ RunTime:0.040710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19176049 ORDER BY `unit` DESC [ RunTime:0.093649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19176049 LIMIT 2 [ RunTime:0.064150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19176049 ORDER BY `minOrder` ASC [ RunTime:0.014787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17107508 LIMIT 5 [ RunTime:0.047180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17107508 ORDER BY `minOrder` ASC [ RunTime:0.065937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17107508 ORDER BY `unit` DESC [ RunTime:0.109694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17107508 LIMIT 2 [ RunTime:0.084381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17107508 ORDER BY `minOrder` ASC [ RunTime:0.011952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186326 LIMIT 5 [ RunTime:0.011095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186326 ORDER BY `minOrder` ASC [ RunTime:0.053618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11186326 ORDER BY `unit` DESC [ RunTime:0.131867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11186326 LIMIT 2 [ RunTime:0.063291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186326 ORDER BY `minOrder` ASC [ RunTime:0.024074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267637 LIMIT 5 [ RunTime:0.034000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267637 ORDER BY `minOrder` ASC [ RunTime:0.026468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17267637 ORDER BY `unit` DESC [ RunTime:0.026465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17267637 LIMIT 2 [ RunTime:0.059535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267637 ORDER BY `minOrder` ASC [ RunTime:0.041199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284872 LIMIT 5 [ RunTime:0.045545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284872 ORDER BY `minOrder` ASC [ RunTime:0.051171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13284872 ORDER BY `unit` DESC [ RunTime:0.030350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13284872 LIMIT 2 [ RunTime:0.053419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284872 ORDER BY `minOrder` ASC [ RunTime:0.024869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284821 LIMIT 5 [ RunTime:0.026313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284821 ORDER BY `minOrder` ASC [ RunTime:0.026758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13284821 ORDER BY `unit` DESC [ RunTime:0.015881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13284821 LIMIT 2 [ RunTime:0.025607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284821 ORDER BY `minOrder` ASC [ RunTime:0.034659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12228660 LIMIT 5 [ RunTime:0.024746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12228660 ORDER BY `minOrder` ASC [ RunTime:0.013143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12228660 ORDER BY `unit` DESC [ RunTime:0.006710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12228660 LIMIT 2 [ RunTime:0.026324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12228660 ORDER BY `minOrder` ASC [ RunTime:0.006283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12016537 LIMIT 5 [ RunTime:0.007774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016537 ORDER BY `minOrder` ASC [ RunTime:0.003185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12016537 ORDER BY `unit` DESC [ RunTime:0.006885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12016537 LIMIT 2 [ RunTime:0.001389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016537 ORDER BY `minOrder` ASC [ RunTime:0.003542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014700 LIMIT 5 [ RunTime:0.027237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014700 ORDER BY `minOrder` ASC [ RunTime:0.025168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12014700 ORDER BY `unit` DESC [ RunTime:0.066208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12014700 LIMIT 2 [ RunTime:0.021073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014700 ORDER BY `minOrder` ASC [ RunTime:0.004959s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027818s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63802269 LIMIT 5 [ RunTime:0.051595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63802269 ORDER BY `minOrder` ASC [ RunTime:0.030165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63802269 ORDER BY `unit` DESC [ RunTime:0.051439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63802269 LIMIT 2 [ RunTime:0.009531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63802269 ORDER BY `minOrder` ASC [ RunTime:0.002975s ]
select * from pdf where partno='54175/BFA' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.029726s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54175/BFA' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.029192s ]
SELECT `id` FROM `stock` WHERE `id` <> 63802269 AND `partno` = '54175/BFA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.049159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19176053 [ RunTime:0.060928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64573639 LIMIT 5 [ RunTime:0.097122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64573639 ORDER BY `minOrder` ASC [ RunTime:0.044694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64573639 ORDER BY `unit` DESC [ RunTime:0.029440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64573639 LIMIT 2 [ RunTime:0.036471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64573639 ORDER BY `minOrder` ASC [ RunTime:0.006518s ]
select * from pdf where partno='5417CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.047106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5417CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.030974s ]
SELECT `id` FROM `stock` WHERE `id` <> 64573639 AND `partno` = '5417CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.056122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344075 [ RunTime:0.007198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63802257 LIMIT 5 [ RunTime:0.026676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63802257 ORDER BY `minOrder` ASC [ RunTime:0.020162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63802257 ORDER BY `unit` DESC [ RunTime:0.188095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63802257 LIMIT 2 [ RunTime:0.091957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63802257 ORDER BY `minOrder` ASC [ RunTime:0.013997s ]
select * from pdf where partno='54175/BEA' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.034247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54175/BEA' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.020206s ]
SELECT `id` FROM `stock` WHERE `id` <> 63802257 AND `partno` = '54175/BEA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.053411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19176049 [ RunTime:0.040374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63822021 LIMIT 5 [ RunTime:0.082867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63822021 ORDER BY `minOrder` ASC [ RunTime:0.041184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63822021 ORDER BY `unit` DESC [ RunTime:0.022904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63822021 LIMIT 2 [ RunTime:0.076933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63822021 ORDER BY `minOrder` ASC [ RunTime:0.034050s ]
select * from pdf where partno='54170DM' and brandshort='National Semiconductor' limit 1 [ RunTime:0.028146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54170DM' OR `brand` LIKE 'National Semiconductor%' ) ) LIMIT 1 [ RunTime:0.062570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63863664 LIMIT 5 [ RunTime:0.027108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63863664 ORDER BY `minOrder` ASC [ RunTime:0.022011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63863664 ORDER BY `unit` DESC [ RunTime:0.025708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63863664 LIMIT 2 [ RunTime:0.015774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63863664 ORDER BY `minOrder` ASC [ RunTime:0.001525s ]
select * from pdf where partno='54177J/B' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.019098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54177J/B' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.018357s ]
SELECT `id` FROM `stock` WHERE `id` <> 63863664 AND `partno` = '54177J/B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.001732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17107508 [ RunTime:0.016980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58513841 LIMIT 5 [ RunTime:0.011761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513841 ORDER BY `minOrder` ASC [ RunTime:0.022592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58513841 ORDER BY `unit` DESC [ RunTime:0.021625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58513841 LIMIT 2 [ RunTime:0.008246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513841 ORDER BY `minOrder` ASC [ RunTime:0.024642s ]
select * from pdf where partno='5417' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.014181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5417' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.014546s ]
SELECT `id` FROM `stock` WHERE `id` <> 58513841 AND `partno` = '5417' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.023083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186326 [ RunTime:0.008585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019555 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019555 ORDER BY `minOrder` ASC [ RunTime:0.005115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019555 ORDER BY `unit` DESC [ RunTime:0.002571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019555 LIMIT 2 [ RunTime:0.005904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019555 ORDER BY `minOrder` ASC [ RunTime:0.002915s ]
select * from pdf where partno='5417' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5417' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.004766s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019555 AND `partno` = '5417' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.007725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267637 [ RunTime:0.013435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58516599 LIMIT 5 [ RunTime:0.012932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58516599 ORDER BY `minOrder` ASC [ RunTime:0.008442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58516599 ORDER BY `unit` DESC [ RunTime:0.002924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58516599 LIMIT 2 [ RunTime:0.005308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58516599 ORDER BY `minOrder` ASC [ RunTime:0.005521s ]
select * from pdf where partno='5417T' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.010040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5417T' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001654s ]
SELECT `id` FROM `stock` WHERE `id` <> 58516599 AND `partno` = '5417T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.006324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58157646 LIMIT 5 [ RunTime:0.006848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58157646 ORDER BY `minOrder` ASC [ RunTime:0.037424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58157646 ORDER BY `unit` DESC [ RunTime:0.009354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58157646 LIMIT 2 [ RunTime:0.003784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58157646 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
select * from pdf where partno='5417549-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5417549-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010615s ]
SELECT `id` FROM `stock` WHERE `id` <> 58157646 AND `partno` = '5417549-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12228660 [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32608260 LIMIT 5 [ RunTime:0.014374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608260 ORDER BY `minOrder` ASC [ RunTime:0.006192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32608260 ORDER BY `unit` DESC [ RunTime:0.002077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32608260 LIMIT 2 [ RunTime:0.004382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608260 ORDER BY `minOrder` ASC [ RunTime:0.010866s ]
select * from pdf where partno='541763-000' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '541763-000' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014801s ]
SELECT `id` FROM `stock` WHERE `id` <> 32608260 AND `partno` = '541763-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32380004 LIMIT 5 [ RunTime:0.019493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32380004 ORDER BY `minOrder` ASC [ RunTime:0.030868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32380004 ORDER BY `unit` DESC [ RunTime:0.042450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32380004 LIMIT 2 [ RunTime:0.035750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32380004 ORDER BY `minOrder` ASC [ RunTime:0.001992s ]
select * from pdf where partno='54170' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.027678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54170' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.048676s ]
SELECT `id` FROM `stock` WHERE `id` <> 32380004 AND `partno` = '54170' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.064438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12016537 [ RunTime:0.027971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32364406 LIMIT 5 [ RunTime:0.085028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32364406 ORDER BY `minOrder` ASC [ RunTime:0.059830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32364406 ORDER BY `unit` DESC [ RunTime:0.053784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32364406 LIMIT 2 [ RunTime:0.035688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32364406 ORDER BY `minOrder` ASC [ RunTime:0.035002s ]
select * from pdf where partno='54171' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.043735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54171' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.026390s ]
SELECT `id` FROM `stock` WHERE `id` <> 32364406 AND `partno` = '54171' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.072710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284872 [ RunTime:0.098133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32363593 LIMIT 5 [ RunTime:0.072481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32363593 ORDER BY `minOrder` ASC [ RunTime:0.042349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32363593 ORDER BY `unit` DESC [ RunTime:0.049319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32363593 LIMIT 2 [ RunTime:0.054774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32363593 ORDER BY `minOrder` ASC [ RunTime:0.030335s ]
select * from pdf where partno='54172G' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.047882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54172G' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.042096s ]
SELECT `id` FROM `stock` WHERE `id` <> 32363593 AND `partno` = '54172G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.040604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284821 [ RunTime:0.073993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32355216 LIMIT 5 [ RunTime:0.032407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32355216 ORDER BY `minOrder` ASC [ RunTime:0.036654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32355216 ORDER BY `unit` DESC [ RunTime:0.018918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32355216 LIMIT 2 [ RunTime:0.017952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32355216 ORDER BY `minOrder` ASC [ RunTime:0.007809s ]
select * from pdf where partno='54179' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.044445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '54179' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.088240s ]
SELECT `id` FROM `stock` WHERE `id` <> 32355216 AND `partno` = '54179' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.057241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014700 [ RunTime:0.066761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32313118 LIMIT 5 [ RunTime:0.059561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32313118 ORDER BY `minOrder` ASC [ RunTime:0.016159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32313118 ORDER BY `unit` DESC [ RunTime:0.026338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32313118 LIMIT 2 [ RunTime:0.058917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32313118 ORDER BY `minOrder` ASC [ RunTime:0.055757s ]
select * from pdf where partno='5417' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.134691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5417' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.061576s ]
SELECT `id` FROM `stock` WHERE `id` <> 32313118 AND `partno` = '5417' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.097257s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071262s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063417s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047979s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074388s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051364s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007495s ]
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 '5417%' OR `brand` LIKE '5417%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052619s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5417%' OR `brand` LIKE '5417%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019631s ]