SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001644s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=6109&search=1' [ RunTime:0.007625s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001816s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.012625s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004446s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.005762s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002005s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005110s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002053s ]
SELECT * FROM `stock_search` WHERE `partno` = '6109' LIMIT 1 [ RunTime:0.010812s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-10 15:25:46' WHERE `partno` = '6109' [ RunTime:0.010740s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001485s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011160s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519032 LIMIT 5 [ RunTime:0.006101s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519032 ORDER BY `minOrder` ASC [ RunTime:0.004591s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519032 ORDER BY `unit` DESC [ RunTime:0.008364s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519032 LIMIT 2 [ RunTime:0.011103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519032 ORDER BY `minOrder` ASC [ RunTime:0.015286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593236 LIMIT 5 [ RunTime:0.005321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593236 ORDER BY `minOrder` ASC [ RunTime:0.011798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593236 ORDER BY `unit` DESC [ RunTime:0.004919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593236 LIMIT 2 [ RunTime:0.007627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593236 ORDER BY `minOrder` ASC [ RunTime:0.014964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299865 LIMIT 5 [ RunTime:0.014546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299865 ORDER BY `minOrder` ASC [ RunTime:0.014607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17299865 ORDER BY `unit` DESC [ RunTime:0.020428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17299865 LIMIT 2 [ RunTime:0.005782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299865 ORDER BY `minOrder` ASC [ RunTime:0.007682s ]
select * from pdf where partno='6109-0-00-15-00-00-03-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.002970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392691 LIMIT 5 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392691 ORDER BY `minOrder` ASC [ RunTime:0.005576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392691 ORDER BY `unit` DESC [ RunTime:0.002438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392691 LIMIT 2 [ RunTime:0.011640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392691 ORDER BY `minOrder` ASC [ RunTime:0.011266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140257 LIMIT 5 [ RunTime:0.001299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140257 ORDER BY `minOrder` ASC [ RunTime:0.003721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140257 ORDER BY `unit` DESC [ RunTime:0.002397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140257 LIMIT 2 [ RunTime:0.003003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140257 ORDER BY `minOrder` ASC [ RunTime:0.014257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866134 LIMIT 5 [ RunTime:0.034963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866134 ORDER BY `minOrder` ASC [ RunTime:0.040085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18866134 ORDER BY `unit` DESC [ RunTime:0.023021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18866134 LIMIT 2 [ RunTime:0.028054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866134 ORDER BY `minOrder` ASC [ RunTime:0.024823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18658145 LIMIT 5 [ RunTime:0.024684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18658145 ORDER BY `minOrder` ASC [ RunTime:0.035714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18658145 ORDER BY `unit` DESC [ RunTime:0.016064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18658145 LIMIT 2 [ RunTime:0.042502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18658145 ORDER BY `minOrder` ASC [ RunTime:0.029405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18646658 LIMIT 5 [ RunTime:0.025339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18646658 ORDER BY `minOrder` ASC [ RunTime:0.058707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18646658 ORDER BY `unit` DESC [ RunTime:0.025869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18646658 LIMIT 2 [ RunTime:0.035572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18646658 ORDER BY `minOrder` ASC [ RunTime:0.017098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15442726 LIMIT 5 [ RunTime:0.033708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442726 ORDER BY `minOrder` ASC [ RunTime:0.050786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15442726 ORDER BY `unit` DESC [ RunTime:0.012195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15442726 LIMIT 2 [ RunTime:0.011649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442726 ORDER BY `minOrder` ASC [ RunTime:0.000895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292627 LIMIT 5 [ RunTime:0.001192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292627 ORDER BY `minOrder` ASC [ RunTime:0.002573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13292627 ORDER BY `unit` DESC [ RunTime:0.002322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13292627 LIMIT 2 [ RunTime:0.001255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292627 ORDER BY `minOrder` ASC [ RunTime:0.001489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186446 LIMIT 5 [ RunTime:0.007897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186446 ORDER BY `minOrder` ASC [ RunTime:0.002822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186446 ORDER BY `unit` DESC [ RunTime:0.005024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186446 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186446 ORDER BY `minOrder` ASC [ RunTime:0.001274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186445 LIMIT 5 [ RunTime:0.006417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186445 ORDER BY `minOrder` ASC [ RunTime:0.003417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186445 ORDER BY `unit` DESC [ RunTime:0.008657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186445 LIMIT 2 [ RunTime:0.015306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186445 ORDER BY `minOrder` ASC [ RunTime:0.005823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12044657 LIMIT 5 [ RunTime:0.001870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12044657 ORDER BY `minOrder` ASC [ RunTime:0.002059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12044657 ORDER BY `unit` DESC [ RunTime:0.014373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12044657 LIMIT 2 [ RunTime:0.006882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12044657 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11197105 LIMIT 5 [ RunTime:0.001949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11197105 ORDER BY `minOrder` ASC [ RunTime:0.002599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11197105 ORDER BY `unit` DESC [ RunTime:0.013263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11197105 LIMIT 2 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11197105 ORDER BY `minOrder` ASC [ RunTime:0.004779s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001347s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639530 LIMIT 5 [ RunTime:0.005084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639530 ORDER BY `minOrder` ASC [ RunTime:0.005451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639530 ORDER BY `unit` DESC [ RunTime:0.002119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639530 LIMIT 2 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639530 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
select * from pdf where partno='61095-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002072s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61095-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006574s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639530 AND `partno` = '61095-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519032 [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60310591 LIMIT 5 [ RunTime:0.001677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310591 ORDER BY `minOrder` ASC [ RunTime:0.001553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60310591 ORDER BY `unit` DESC [ RunTime:0.003384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60310591 LIMIT 2 [ RunTime:0.006412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310591 ORDER BY `minOrder` ASC [ RunTime:0.002651s ]
select * from pdf where partno='61097-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61097-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001669s ]
SELECT `id` FROM `stock` WHERE `id` <> 60310591 AND `partno` = '61097-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593236 [ RunTime:0.008447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64048765 LIMIT 5 [ RunTime:0.002907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64048765 ORDER BY `minOrder` ASC [ RunTime:0.000849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64048765 ORDER BY `unit` DESC [ RunTime:0.003735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64048765 LIMIT 2 [ RunTime:0.000261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64048765 ORDER BY `minOrder` ASC [ RunTime:0.000176s ]
select * from pdf where partno='6109' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6109' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.008763s ]
SELECT `id` FROM `stock` WHERE `id` <> 64048765 AND `partno` = '6109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392691 [ RunTime:0.000545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60311521 LIMIT 5 [ RunTime:0.006894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60311521 ORDER BY `minOrder` ASC [ RunTime:0.005834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60311521 ORDER BY `unit` DESC [ RunTime:0.003666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60311521 LIMIT 2 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60311521 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='6109-0-00-15-00-00-03-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6109-0-00-15-00-00-03-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001603s ]
SELECT `id` FROM `stock` WHERE `id` <> 60311521 AND `partno` = '6109-0-00-15-00-00-03-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299865 [ RunTime:0.006260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64438328 LIMIT 5 [ RunTime:0.004643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64438328 ORDER BY `minOrder` ASC [ RunTime:0.001452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64438328 ORDER BY `unit` DESC [ RunTime:0.005594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64438328 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64438328 ORDER BY `minOrder` ASC [ RunTime:0.001351s ]
select * from pdf where partno='61093' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.001041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61093' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.006250s ]
SELECT `id` FROM `stock` WHERE `id` <> 64438328 AND `partno` = '61093' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.000973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140257 [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63363488 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63363488 ORDER BY `minOrder` ASC [ RunTime:0.005579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63363488 ORDER BY `unit` DESC [ RunTime:0.004812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63363488 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63363488 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='61090' and brandshort='Weidmüller' limit 1 [ RunTime:0.005888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61090' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001824s ]
SELECT `id` FROM `stock` WHERE `id` <> 63363488 AND `partno` = '61090' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12044657 [ RunTime:0.006454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313201 LIMIT 5 [ RunTime:0.004015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313201 ORDER BY `minOrder` ASC [ RunTime:0.002208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313201 ORDER BY `unit` DESC [ RunTime:0.002392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313201 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313201 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='6109-0-00-80-00-00-03-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6109-0-00-80-00-00-03-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001324s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313201 AND `partno` = '6109-0-00-80-00-00-03-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.001027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60312236 LIMIT 5 [ RunTime:0.001905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60312236 ORDER BY `minOrder` ASC [ RunTime:0.001139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60312236 ORDER BY `unit` DESC [ RunTime:0.007587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60312236 LIMIT 2 [ RunTime:0.001633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60312236 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
select * from pdf where partno='61097-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61097-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000889s ]
SELECT `id` FROM `stock` WHERE `id` <> 60312236 AND `partno` = '61097-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15442726 [ RunTime:0.004995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58582333 LIMIT 5 [ RunTime:0.000883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58582333 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58582333 ORDER BY `unit` DESC [ RunTime:0.002290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58582333 LIMIT 2 [ RunTime:0.000864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58582333 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='6109' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6109' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.002714s ]
SELECT `id` FROM `stock` WHERE `id` <> 58582333 AND `partno` = '6109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.001014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58554942 LIMIT 5 [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554942 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58554942 ORDER BY `unit` DESC [ RunTime:0.004370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58554942 LIMIT 2 [ RunTime:0.008966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554942 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='61092' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.000310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61092' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.000234s ]
SELECT `id` FROM `stock` WHERE `id` <> 58554942 AND `partno` = '61092' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.002461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186445 [ RunTime:0.000788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58553458 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58553458 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58553458 ORDER BY `unit` DESC [ RunTime:0.004061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58553458 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58553458 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
select * from pdf where partno='61093G' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.000530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61093G' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.000518s ]
SELECT `id` FROM `stock` WHERE `id` <> 58553458 AND `partno` = '61093G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11197105 [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58544270 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58544270 ORDER BY `minOrder` ASC [ RunTime:0.002594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58544270 ORDER BY `unit` DESC [ RunTime:0.005672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58544270 LIMIT 2 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58544270 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
select * from pdf where partno='61094' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61094' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.001018s ]
SELECT `id` FROM `stock` WHERE `id` <> 58544270 AND `partno` = '61094' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292627 [ RunTime:0.003140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43903763 LIMIT 5 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43903763 ORDER BY `minOrder` ASC [ RunTime:0.005925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43903763 ORDER BY `unit` DESC [ RunTime:0.008010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43903763 LIMIT 2 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43903763 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='6109B-MT5-CNE42-G5G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6109B-MT5-CNE42-G5G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.001653s ]
SELECT `id` FROM `stock` WHERE `id` <> 43903763 AND `partno` = '6109B-MT5-CNE42-G5G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.002199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18658145 [ RunTime:0.001047s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003501s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004314s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002088s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000895s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000621s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002157s ]
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 '6109%' OR `brand` LIKE '6109%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000716s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6109%' OR `brand` LIKE '6109%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004320s ]