SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002374s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=10293&search=1' [ RunTime:0.005746s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001767s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000742s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001450s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.004013s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001342s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005492s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001314s ]
SELECT * FROM `stock_search` WHERE `partno` = '10293' LIMIT 1 [ RunTime:0.006309s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-05 12:27:14' WHERE `partno` = '10293' [ RunTime:0.014431s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001210s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035751s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12886448 LIMIT 5 [ RunTime:0.020049s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12886448 ORDER BY `minOrder` ASC [ RunTime:0.035323s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12886448 ORDER BY `unit` DESC [ RunTime:0.009828s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12886448 LIMIT 2 [ RunTime:0.019253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12886448 ORDER BY `minOrder` ASC [ RunTime:0.010046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12886440 LIMIT 5 [ RunTime:0.014682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12886440 ORDER BY `minOrder` ASC [ RunTime:0.036177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12886440 ORDER BY `unit` DESC [ RunTime:0.016682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12886440 LIMIT 2 [ RunTime:0.048955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12886440 ORDER BY `minOrder` ASC [ RunTime:0.021800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884721 LIMIT 5 [ RunTime:0.023705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884721 ORDER BY `minOrder` ASC [ RunTime:0.033628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12884721 ORDER BY `unit` DESC [ RunTime:0.045595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12884721 LIMIT 2 [ RunTime:0.041967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884721 ORDER BY `minOrder` ASC [ RunTime:0.011540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19665171 LIMIT 5 [ RunTime:0.018735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19665171 ORDER BY `minOrder` ASC [ RunTime:0.020740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19665171 ORDER BY `unit` DESC [ RunTime:0.018944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19665171 LIMIT 2 [ RunTime:0.080354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19665171 ORDER BY `minOrder` ASC [ RunTime:0.010035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684628 LIMIT 5 [ RunTime:0.029185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684628 ORDER BY `minOrder` ASC [ RunTime:0.011218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11684628 ORDER BY `unit` DESC [ RunTime:0.033658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11684628 LIMIT 2 [ RunTime:0.007188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684628 ORDER BY `minOrder` ASC [ RunTime:0.003641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648400 LIMIT 5 [ RunTime:0.009098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648400 ORDER BY `minOrder` ASC [ RunTime:0.010150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19648400 ORDER BY `unit` DESC [ RunTime:0.036619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19648400 LIMIT 2 [ RunTime:0.028108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648400 ORDER BY `minOrder` ASC [ RunTime:0.013362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647263 LIMIT 5 [ RunTime:0.025485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647263 ORDER BY `minOrder` ASC [ RunTime:0.034404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647263 ORDER BY `unit` DESC [ RunTime:0.016100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647263 LIMIT 2 [ RunTime:0.041173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647263 ORDER BY `minOrder` ASC [ RunTime:0.016667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645805 LIMIT 5 [ RunTime:0.024062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645805 ORDER BY `minOrder` ASC [ RunTime:0.012069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19645805 ORDER BY `unit` DESC [ RunTime:0.012821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19645805 LIMIT 2 [ RunTime:0.010079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645805 ORDER BY `minOrder` ASC [ RunTime:0.006797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642314 LIMIT 5 [ RunTime:0.023577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642314 ORDER BY `minOrder` ASC [ RunTime:0.054514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19642314 ORDER BY `unit` DESC [ RunTime:0.058074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19642314 LIMIT 2 [ RunTime:0.018028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642314 ORDER BY `minOrder` ASC [ RunTime:0.009023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310497 LIMIT 5 [ RunTime:0.041900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310497 ORDER BY `minOrder` ASC [ RunTime:0.019771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17310497 ORDER BY `unit` DESC [ RunTime:0.034208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17310497 LIMIT 2 [ RunTime:0.033442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310497 ORDER BY `minOrder` ASC [ RunTime:0.016072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17301429 LIMIT 5 [ RunTime:0.036780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17301429 ORDER BY `minOrder` ASC [ RunTime:0.022996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17301429 ORDER BY `unit` DESC [ RunTime:0.015978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17301429 LIMIT 2 [ RunTime:0.065948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17301429 ORDER BY `minOrder` ASC [ RunTime:0.045587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17301428 LIMIT 5 [ RunTime:0.064781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17301428 ORDER BY `minOrder` ASC [ RunTime:0.015949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17301428 ORDER BY `unit` DESC [ RunTime:0.012614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17301428 LIMIT 2 [ RunTime:0.069918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17301428 ORDER BY `minOrder` ASC [ RunTime:0.019611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451727 LIMIT 5 [ RunTime:0.038278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451727 ORDER BY `minOrder` ASC [ RunTime:0.021820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15451727 ORDER BY `unit` DESC [ RunTime:0.020069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15451727 LIMIT 2 [ RunTime:0.030316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451727 ORDER BY `minOrder` ASC [ RunTime:0.021539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15450639 LIMIT 5 [ RunTime:0.046163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15450639 ORDER BY `minOrder` ASC [ RunTime:0.018805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15450639 ORDER BY `unit` DESC [ RunTime:0.027184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15450639 LIMIT 2 [ RunTime:0.013715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15450639 ORDER BY `minOrder` ASC [ RunTime:0.009744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13359179 LIMIT 5 [ RunTime:0.014516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13359179 ORDER BY `minOrder` ASC [ RunTime:0.012377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13359179 ORDER BY `unit` DESC [ RunTime:0.049123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13359179 LIMIT 2 [ RunTime:0.013713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13359179 ORDER BY `minOrder` ASC [ RunTime:0.013150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12885223 LIMIT 5 [ RunTime:0.032638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885223 ORDER BY `minOrder` ASC [ RunTime:0.024759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12885223 ORDER BY `unit` DESC [ RunTime:0.036479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12885223 LIMIT 2 [ RunTime:0.017599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885223 ORDER BY `minOrder` ASC [ RunTime:0.005604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12885217 LIMIT 5 [ RunTime:0.075259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885217 ORDER BY `minOrder` ASC [ RunTime:0.048796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12885217 ORDER BY `unit` DESC [ RunTime:0.023220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12885217 LIMIT 2 [ RunTime:0.044465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885217 ORDER BY `minOrder` ASC [ RunTime:0.021144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799023 LIMIT 5 [ RunTime:0.044805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799023 ORDER BY `minOrder` ASC [ RunTime:0.050746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799023 ORDER BY `unit` DESC [ RunTime:0.054493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799023 LIMIT 2 [ RunTime:0.031711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799023 ORDER BY `minOrder` ASC [ RunTime:0.019613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11868327 LIMIT 5 [ RunTime:0.060179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11868327 ORDER BY `minOrder` ASC [ RunTime:0.049546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11868327 ORDER BY `unit` DESC [ RunTime:0.044569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11868327 LIMIT 2 [ RunTime:0.033459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11868327 ORDER BY `minOrder` ASC [ RunTime:0.013779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684889 LIMIT 5 [ RunTime:0.020140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684889 ORDER BY `minOrder` ASC [ RunTime:0.018264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11684889 ORDER BY `unit` DESC [ RunTime:0.052577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11684889 LIMIT 2 [ RunTime:0.015453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684889 ORDER BY `minOrder` ASC [ RunTime:0.025284s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041241s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339711 LIMIT 5 [ RunTime:0.002228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339711 ORDER BY `minOrder` ASC [ RunTime:0.033496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60339711 ORDER BY `unit` DESC [ RunTime:0.056850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60339711 LIMIT 2 [ RunTime:0.032781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339711 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='1029395' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013613s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029395' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.051120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339561 LIMIT 5 [ RunTime:0.009567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339561 ORDER BY `minOrder` ASC [ RunTime:0.030623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60339561 ORDER BY `unit` DESC [ RunTime:0.002656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60339561 LIMIT 2 [ RunTime:0.028295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339561 ORDER BY `minOrder` ASC [ RunTime:0.029028s ]
select * from pdf where partno='1029394' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029394' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.034057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64566220 LIMIT 5 [ RunTime:0.020040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566220 ORDER BY `minOrder` ASC [ RunTime:0.018741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64566220 ORDER BY `unit` DESC [ RunTime:0.014463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64566220 LIMIT 2 [ RunTime:0.029903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566220 ORDER BY `minOrder` ASC [ RunTime:0.026550s ]
select * from pdf where partno='10293CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.025457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10293CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.027934s ]
SELECT `id` FROM `stock` WHERE `id` <> 64566220 AND `partno` = '10293CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.020914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339708 LIMIT 5 [ RunTime:0.016319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339708 ORDER BY `minOrder` ASC [ RunTime:0.025496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60339708 ORDER BY `unit` DESC [ RunTime:0.020634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60339708 LIMIT 2 [ RunTime:0.041268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339708 ORDER BY `minOrder` ASC [ RunTime:0.041231s ]
select * from pdf where partno='1029389' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.026586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029389' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.036517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339911 LIMIT 5 [ RunTime:0.073430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339911 ORDER BY `minOrder` ASC [ RunTime:0.023928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60339911 ORDER BY `unit` DESC [ RunTime:0.016011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60339911 LIMIT 2 [ RunTime:0.045386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339911 ORDER BY `minOrder` ASC [ RunTime:0.019621s ]
select * from pdf where partno='1029398' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.046487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029398' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.036403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61004078 LIMIT 5 [ RunTime:0.006505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61004078 ORDER BY `minOrder` ASC [ RunTime:0.051606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61004078 ORDER BY `unit` DESC [ RunTime:0.025375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61004078 LIMIT 2 [ RunTime:0.022824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61004078 ORDER BY `minOrder` ASC [ RunTime:0.055321s ]
select * from pdf where partno='1029300000' and brandshort='Weidmüller' limit 1 [ RunTime:0.039212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029300000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.033167s ]
SELECT `id` FROM `stock` WHERE `id` <> 61004078 AND `partno` = '1029300000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.045492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19665171 [ RunTime:0.054557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339866 LIMIT 5 [ RunTime:0.100306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339866 ORDER BY `minOrder` ASC [ RunTime:0.034459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60339866 ORDER BY `unit` DESC [ RunTime:0.134657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60339866 LIMIT 2 [ RunTime:0.025383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339866 ORDER BY `minOrder` ASC [ RunTime:0.008308s ]
select * from pdf where partno='1029396' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.032247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029396' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.058199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380775 LIMIT 5 [ RunTime:0.017754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380775 ORDER BY `minOrder` ASC [ RunTime:0.048648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380775 ORDER BY `unit` DESC [ RunTime:0.095859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380775 LIMIT 2 [ RunTime:0.011846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380775 ORDER BY `minOrder` ASC [ RunTime:0.009864s ]
select * from pdf where partno='10293F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.046211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10293F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.029109s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380775 AND `partno` = '10293F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.012041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380089 LIMIT 5 [ RunTime:0.006456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380089 ORDER BY `minOrder` ASC [ RunTime:0.012995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380089 ORDER BY `unit` DESC [ RunTime:0.014210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380089 LIMIT 2 [ RunTime:0.020216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380089 ORDER BY `minOrder` ASC [ RunTime:0.017355s ]
select * from pdf where partno='10293' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.025124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10293' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.010876s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380089 AND `partno` = '10293' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.024269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62106268 LIMIT 5 [ RunTime:0.035829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62106268 ORDER BY `minOrder` ASC [ RunTime:0.011072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62106268 ORDER BY `unit` DESC [ RunTime:0.020446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62106268 LIMIT 2 [ RunTime:0.018219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62106268 ORDER BY `minOrder` ASC [ RunTime:0.015439s ]
select * from pdf where partno='1029334' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029334' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.047030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60573329 LIMIT 5 [ RunTime:0.034887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60573329 ORDER BY `minOrder` ASC [ RunTime:0.046525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60573329 ORDER BY `unit` DESC [ RunTime:0.010097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60573329 LIMIT 2 [ RunTime:0.006968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60573329 ORDER BY `minOrder` ASC [ RunTime:0.007639s ]
select * from pdf where partno='10293.4' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.026749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10293.4' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.018205s ]
SELECT `id` FROM `stock` WHERE `id` <> 60573329 AND `partno` = '10293.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.054662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17301429 [ RunTime:0.082280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60573328 LIMIT 5 [ RunTime:0.071023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60573328 ORDER BY `minOrder` ASC [ RunTime:0.013631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60573328 ORDER BY `unit` DESC [ RunTime:0.056494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60573328 LIMIT 2 [ RunTime:0.071813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60573328 ORDER BY `minOrder` ASC [ RunTime:0.039581s ]
select * from pdf where partno='10293.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.025906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10293.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.048228s ]
SELECT `id` FROM `stock` WHERE `id` <> 60573328 AND `partno` = '10293.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.040351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17301428 [ RunTime:0.048690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60547521 LIMIT 5 [ RunTime:0.021903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60547521 ORDER BY `minOrder` ASC [ RunTime:0.025314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60547521 ORDER BY `unit` DESC [ RunTime:0.030073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60547521 LIMIT 2 [ RunTime:0.015468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60547521 ORDER BY `minOrder` ASC [ RunTime:0.005772s ]
select * from pdf where partno='1029370000' and brandshort='Weidmüller' limit 1 [ RunTime:0.017876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029370000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029428s ]
SELECT `id` FROM `stock` WHERE `id` <> 60547521 AND `partno` = '1029370000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451727 [ RunTime:0.010378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60546229 LIMIT 5 [ RunTime:0.023000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60546229 ORDER BY `minOrder` ASC [ RunTime:0.018321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60546229 ORDER BY `unit` DESC [ RunTime:0.026425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60546229 LIMIT 2 [ RunTime:0.036973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60546229 ORDER BY `minOrder` ASC [ RunTime:0.023072s ]
select * from pdf where partno='1029360000' and brandshort='Weidmüller' limit 1 [ RunTime:0.032847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029360000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.030015s ]
SELECT `id` FROM `stock` WHERE `id` <> 60546229 AND `partno` = '1029360000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.036481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310497 [ RunTime:0.029499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60544758 LIMIT 5 [ RunTime:0.012990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60544758 ORDER BY `minOrder` ASC [ RunTime:0.012672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60544758 ORDER BY `unit` DESC [ RunTime:0.007387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60544758 LIMIT 2 [ RunTime:0.022102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60544758 ORDER BY `minOrder` ASC [ RunTime:0.033294s ]
select * from pdf where partno='1029350000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029350000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.012500s ]
SELECT `id` FROM `stock` WHERE `id` <> 60544758 AND `partno` = '1029350000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.037520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648400 [ RunTime:0.013296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60543130 LIMIT 5 [ RunTime:0.007090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60543130 ORDER BY `minOrder` ASC [ RunTime:0.029352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60543130 ORDER BY `unit` DESC [ RunTime:0.017769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60543130 LIMIT 2 [ RunTime:0.037102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60543130 ORDER BY `minOrder` ASC [ RunTime:0.021736s ]
select * from pdf where partno='1029340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.051077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029340000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014010s ]
SELECT `id` FROM `stock` WHERE `id` <> 60543130 AND `partno` = '1029340000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647263 [ RunTime:0.022287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60541334 LIMIT 5 [ RunTime:0.035630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60541334 ORDER BY `minOrder` ASC [ RunTime:0.032223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60541334 ORDER BY `unit` DESC [ RunTime:0.007329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60541334 LIMIT 2 [ RunTime:0.006482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60541334 ORDER BY `minOrder` ASC [ RunTime:0.009196s ]
select * from pdf where partno='1029330000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029330000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.019591s ]
SELECT `id` FROM `stock` WHERE `id` <> 60541334 AND `partno` = '1029330000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.022937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645805 [ RunTime:0.019522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60539124 LIMIT 5 [ RunTime:0.005431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60539124 ORDER BY `minOrder` ASC [ RunTime:0.010139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60539124 ORDER BY `unit` DESC [ RunTime:0.012290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60539124 LIMIT 2 [ RunTime:0.014297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60539124 ORDER BY `minOrder` ASC [ RunTime:0.002900s ]
select * from pdf where partno='1029320000' and brandshort='Weidmüller' limit 1 [ RunTime:0.025237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029320000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006476s ]
SELECT `id` FROM `stock` WHERE `id` <> 60539124 AND `partno` = '1029320000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15450639 [ RunTime:0.003200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60536597 LIMIT 5 [ RunTime:0.005946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60536597 ORDER BY `minOrder` ASC [ RunTime:0.015051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60536597 ORDER BY `unit` DESC [ RunTime:0.005675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60536597 LIMIT 2 [ RunTime:0.016915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60536597 ORDER BY `minOrder` ASC [ RunTime:0.012976s ]
select * from pdf where partno='1029310000' and brandshort='Weidmüller' limit 1 [ RunTime:0.034290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029310000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029249s ]
SELECT `id` FROM `stock` WHERE `id` <> 60536597 AND `partno` = '1029310000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.046025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642314 [ RunTime:0.030799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60340935 LIMIT 5 [ RunTime:0.025419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60340935 ORDER BY `minOrder` ASC [ RunTime:0.015330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60340935 ORDER BY `unit` DESC [ RunTime:0.018091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60340935 LIMIT 2 [ RunTime:0.039559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60340935 ORDER BY `minOrder` ASC [ RunTime:0.011990s ]
select * from pdf where partno='1029390' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1029390' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021891s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021914s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005082s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018076s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015473s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008488s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030988s ]
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 '10293%' OR `brand` LIKE '10293%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013089s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10293%' OR `brand` LIKE '10293%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030569s ]