SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001928s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=10523&search=1' [ RunTime:0.001898s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002053s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002199s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.003253s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001869s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002984s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001815s ]
SELECT * FROM `stock_search` WHERE `partno` = '10523' LIMIT 1 [ RunTime:0.017221s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 09:23:00' WHERE `partno` = '10523' [ RunTime:0.006861s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002168s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009455s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067440 LIMIT 5 [ RunTime:0.039023s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067440 ORDER BY `minOrder` ASC [ RunTime:0.015380s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.015908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067440 ORDER BY `unit` DESC [ RunTime:0.025029s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067440 LIMIT 2 [ RunTime:0.012244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067440 ORDER BY `minOrder` ASC [ RunTime:0.044178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556496 LIMIT 5 [ RunTime:0.013327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556496 ORDER BY `minOrder` ASC [ RunTime:0.039602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556496 ORDER BY `unit` DESC [ RunTime:0.023941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556496 LIMIT 2 [ RunTime:0.011253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556496 ORDER BY `minOrder` ASC [ RunTime:0.062807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19602634 LIMIT 5 [ RunTime:0.057092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602634 ORDER BY `minOrder` ASC [ RunTime:0.035083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19602634 ORDER BY `unit` DESC [ RunTime:0.019918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19602634 LIMIT 2 [ RunTime:0.025442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602634 ORDER BY `minOrder` ASC [ RunTime:0.007944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140566 LIMIT 5 [ RunTime:0.011205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140566 ORDER BY `minOrder` ASC [ RunTime:0.032127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140566 ORDER BY `unit` DESC [ RunTime:0.009262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140566 LIMIT 2 [ RunTime:0.027684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140566 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140448 LIMIT 5 [ RunTime:0.001301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140448 ORDER BY `minOrder` ASC [ RunTime:0.010111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140448 ORDER BY `unit` DESC [ RunTime:0.015000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140448 LIMIT 2 [ RunTime:0.003022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140448 ORDER BY `minOrder` ASC [ RunTime:0.003961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982695 LIMIT 5 [ RunTime:0.003849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982695 ORDER BY `minOrder` ASC [ RunTime:0.014161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982695 ORDER BY `unit` DESC [ RunTime:0.021916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982695 LIMIT 2 [ RunTime:0.013597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982695 ORDER BY `minOrder` ASC [ RunTime:0.002382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981350 LIMIT 5 [ RunTime:0.012807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981350 ORDER BY `minOrder` ASC [ RunTime:0.009534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981350 ORDER BY `unit` DESC [ RunTime:0.003249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981350 LIMIT 2 [ RunTime:0.010971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981350 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980025 LIMIT 5 [ RunTime:0.009886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980025 ORDER BY `minOrder` ASC [ RunTime:0.018725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980025 ORDER BY `unit` DESC [ RunTime:0.016639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980025 LIMIT 2 [ RunTime:0.013418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980025 ORDER BY `minOrder` ASC [ RunTime:0.007825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974593 LIMIT 5 [ RunTime:0.001774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974593 ORDER BY `minOrder` ASC [ RunTime:0.009834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974593 ORDER BY `unit` DESC [ RunTime:0.011653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974593 LIMIT 2 [ RunTime:0.006708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974593 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974335 LIMIT 5 [ RunTime:0.009903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974335 ORDER BY `minOrder` ASC [ RunTime:0.013126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974335 ORDER BY `unit` DESC [ RunTime:0.004947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974335 LIMIT 2 [ RunTime:0.004085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974335 ORDER BY `minOrder` ASC [ RunTime:0.034445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835151 LIMIT 5 [ RunTime:0.024201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835151 ORDER BY `minOrder` ASC [ RunTime:0.007737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835151 ORDER BY `unit` DESC [ RunTime:0.014275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835151 LIMIT 2 [ RunTime:0.036936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835151 ORDER BY `minOrder` ASC [ RunTime:0.010883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776018 LIMIT 5 [ RunTime:0.025833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776018 ORDER BY `minOrder` ASC [ RunTime:0.012601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18776018 ORDER BY `unit` DESC [ RunTime:0.008057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18776018 LIMIT 2 [ RunTime:0.010658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776018 ORDER BY `minOrder` ASC [ RunTime:0.002469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774557 LIMIT 5 [ RunTime:0.015857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774557 ORDER BY `minOrder` ASC [ RunTime:0.005328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774557 ORDER BY `unit` DESC [ RunTime:0.017847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774557 LIMIT 2 [ RunTime:0.023914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774557 ORDER BY `minOrder` ASC [ RunTime:0.011627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773400 LIMIT 5 [ RunTime:0.019257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773400 ORDER BY `minOrder` ASC [ RunTime:0.032192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773400 ORDER BY `unit` DESC [ RunTime:0.021674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773400 LIMIT 2 [ RunTime:0.014603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773400 ORDER BY `minOrder` ASC [ RunTime:0.030525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773257 LIMIT 5 [ RunTime:0.021970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773257 ORDER BY `minOrder` ASC [ RunTime:0.015298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773257 ORDER BY `unit` DESC [ RunTime:0.033634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773257 LIMIT 2 [ RunTime:0.018809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773257 ORDER BY `minOrder` ASC [ RunTime:0.012894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773202 LIMIT 5 [ RunTime:0.032798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773202 ORDER BY `minOrder` ASC [ RunTime:0.031628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773202 ORDER BY `unit` DESC [ RunTime:0.006781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773202 LIMIT 2 [ RunTime:0.047082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773202 ORDER BY `minOrder` ASC [ RunTime:0.023595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772945 LIMIT 5 [ RunTime:0.064213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772945 ORDER BY `minOrder` ASC [ RunTime:0.018986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772945 ORDER BY `unit` DESC [ RunTime:0.028410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772945 LIMIT 2 [ RunTime:0.018548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772945 ORDER BY `minOrder` ASC [ RunTime:0.029564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224014 LIMIT 5 [ RunTime:0.028236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224014 ORDER BY `minOrder` ASC [ RunTime:0.034049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224014 ORDER BY `unit` DESC [ RunTime:0.028559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224014 LIMIT 2 [ RunTime:0.022895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224014 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223748 LIMIT 5 [ RunTime:0.018869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223748 ORDER BY `minOrder` ASC [ RunTime:0.032971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223748 ORDER BY `unit` DESC [ RunTime:0.024180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223748 LIMIT 2 [ RunTime:0.032518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223748 ORDER BY `minOrder` ASC [ RunTime:0.030062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12873990 LIMIT 5 [ RunTime:0.062314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12873990 ORDER BY `minOrder` ASC [ RunTime:0.057689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12873990 ORDER BY `unit` DESC [ RunTime:0.081071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12873990 LIMIT 2 [ RunTime:0.071224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12873990 ORDER BY `minOrder` ASC [ RunTime:0.004983s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031397s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.155448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60629443 LIMIT 5 [ RunTime:0.095253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629443 ORDER BY `minOrder` ASC [ RunTime:0.074033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60629443 ORDER BY `unit` DESC [ RunTime:0.045215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60629443 LIMIT 2 [ RunTime:0.040523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629443 ORDER BY `minOrder` ASC [ RunTime:0.008579s ]
select * from pdf where partno='1052360000' and brandshort='Weidmüller' limit 1 [ RunTime:0.029119s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052360000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.044588s ]
SELECT `id` FROM `stock` WHERE `id` <> 60629443 AND `partno` = '1052360000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.029432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57741081 LIMIT 5 [ RunTime:0.029458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57741081 ORDER BY `minOrder` ASC [ RunTime:0.076084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57741081 ORDER BY `unit` DESC [ RunTime:0.028302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57741081 LIMIT 2 [ RunTime:0.032565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57741081 ORDER BY `minOrder` ASC [ RunTime:0.005620s ]
select * from pdf where partno='10523CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.008909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10523CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.022194s ]
SELECT `id` FROM `stock` WHERE `id` <> 57741081 AND `partno` = '10523CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.045452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067440 [ RunTime:0.044155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60621680 LIMIT 5 [ RunTime:0.033898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60621680 ORDER BY `minOrder` ASC [ RunTime:0.046426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60621680 ORDER BY `unit` DESC [ RunTime:0.040345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60621680 LIMIT 2 [ RunTime:0.016453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60621680 ORDER BY `minOrder` ASC [ RunTime:0.052958s ]
select * from pdf where partno='1052332' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.036566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052332' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.034246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622347 LIMIT 5 [ RunTime:0.053457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622347 ORDER BY `minOrder` ASC [ RunTime:0.038322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622347 ORDER BY `unit` DESC [ RunTime:0.025297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622347 LIMIT 2 [ RunTime:0.067428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622347 ORDER BY `minOrder` ASC [ RunTime:0.051515s ]
select * from pdf where partno='1052345:0001' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.051184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0001' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.053670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622354 LIMIT 5 [ RunTime:0.051023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622354 ORDER BY `minOrder` ASC [ RunTime:0.051044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622354 ORDER BY `unit` DESC [ RunTime:0.051019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622354 LIMIT 2 [ RunTime:0.050670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622354 ORDER BY `minOrder` ASC [ RunTime:0.050847s ]
select * from pdf where partno='1052345:0031' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.051181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0031' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.053773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60566466 LIMIT 5 [ RunTime:0.050965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60566466 ORDER BY `minOrder` ASC [ RunTime:0.051577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60566466 ORDER BY `unit` DESC [ RunTime:0.054434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60566466 LIMIT 2 [ RunTime:0.018652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60566466 ORDER BY `minOrder` ASC [ RunTime:0.059337s ]
select * from pdf where partno='1052310000' and brandshort='Weidmüller' limit 1 [ RunTime:0.055725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052310000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.065192s ]
SELECT `id` FROM `stock` WHERE `id` <> 60566466 AND `partno` = '1052310000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.075935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556496 [ RunTime:0.127440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380713 LIMIT 5 [ RunTime:0.059228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380713 ORDER BY `minOrder` ASC [ RunTime:0.066275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380713 ORDER BY `unit` DESC [ RunTime:0.059728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380713 LIMIT 2 [ RunTime:0.059887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380713 ORDER BY `minOrder` ASC [ RunTime:0.086405s ]
select * from pdf where partno='10523F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.042097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10523F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.122067s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380713 AND `partno` = '10523F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.084309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380400 LIMIT 5 [ RunTime:0.068559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380400 ORDER BY `minOrder` ASC [ RunTime:0.027433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380400 ORDER BY `unit` DESC [ RunTime:0.034425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380400 LIMIT 2 [ RunTime:0.079207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380400 ORDER BY `minOrder` ASC [ RunTime:0.081875s ]
select * from pdf where partno='10523' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.021427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10523' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.065953s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380400 AND `partno` = '10523' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.066004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200511 LIMIT 5 [ RunTime:0.021428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200511 ORDER BY `minOrder` ASC [ RunTime:0.047803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200511 ORDER BY `unit` DESC [ RunTime:0.050289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200511 LIMIT 2 [ RunTime:0.029025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200511 ORDER BY `minOrder` ASC [ RunTime:0.022178s ]
select * from pdf where partno='1052324' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052324' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035773s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200511 AND `partno` = '1052324' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.061228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974593 [ RunTime:0.036416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200250 LIMIT 5 [ RunTime:0.050248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200250 ORDER BY `minOrder` ASC [ RunTime:0.041630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200250 ORDER BY `unit` DESC [ RunTime:0.018159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200250 LIMIT 2 [ RunTime:0.042159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200250 ORDER BY `minOrder` ASC [ RunTime:0.025611s ]
select * from pdf where partno='1052389' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.023075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052389' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022535s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200250 AND `partno` = '1052389' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.036378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974335 [ RunTime:0.011109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199842 LIMIT 5 [ RunTime:0.015590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199842 ORDER BY `minOrder` ASC [ RunTime:0.019174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199842 ORDER BY `unit` DESC [ RunTime:0.014868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199842 LIMIT 2 [ RunTime:0.036177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199842 ORDER BY `minOrder` ASC [ RunTime:0.012277s ]
select * from pdf where partno='1052349' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052349' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018393s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199842 AND `partno` = '1052349' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982695 [ RunTime:0.045552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61922348 LIMIT 5 [ RunTime:0.011204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61922348 ORDER BY `minOrder` ASC [ RunTime:0.021278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61922348 ORDER BY `unit` DESC [ RunTime:0.012306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61922348 LIMIT 2 [ RunTime:0.017817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61922348 ORDER BY `minOrder` ASC [ RunTime:0.015213s ]
select * from pdf where partno='1052324-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052324-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010190s ]
SELECT `id` FROM `stock` WHERE `id` <> 61922348 AND `partno` = '1052324-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12873990 [ RunTime:0.013526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625675 LIMIT 5 [ RunTime:0.006754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625675 ORDER BY `minOrder` ASC [ RunTime:0.009674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625675 ORDER BY `unit` DESC [ RunTime:0.023048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625675 LIMIT 2 [ RunTime:0.041376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625675 ORDER BY `minOrder` ASC [ RunTime:0.018489s ]
select * from pdf where partno='1052345:0091' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.021704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0091' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625674 LIMIT 5 [ RunTime:0.009082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625674 ORDER BY `minOrder` ASC [ RunTime:0.011515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625674 ORDER BY `unit` DESC [ RunTime:0.015369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625674 LIMIT 2 [ RunTime:0.028191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625674 ORDER BY `minOrder` ASC [ RunTime:0.011219s ]
select * from pdf where partno='1052345:0071' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0071' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.044405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625673 LIMIT 5 [ RunTime:0.029652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625673 ORDER BY `minOrder` ASC [ RunTime:0.015348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625673 ORDER BY `unit` DESC [ RunTime:0.014872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625673 LIMIT 2 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625673 ORDER BY `minOrder` ASC [ RunTime:0.011357s ]
select * from pdf where partno='1052345:0011' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0011' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625562 LIMIT 5 [ RunTime:0.015319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625562 ORDER BY `minOrder` ASC [ RunTime:0.009763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625562 ORDER BY `unit` DESC [ RunTime:0.013344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625562 LIMIT 2 [ RunTime:0.007309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625562 ORDER BY `minOrder` ASC [ RunTime:0.012728s ]
select * from pdf where partno='1052345:0081' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0081' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625561 LIMIT 5 [ RunTime:0.005275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625561 ORDER BY `minOrder` ASC [ RunTime:0.017237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625561 ORDER BY `unit` DESC [ RunTime:0.017900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625561 LIMIT 2 [ RunTime:0.007963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625561 ORDER BY `minOrder` ASC [ RunTime:0.006694s ]
select * from pdf where partno='1052345:0061' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.012817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0061' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625560 LIMIT 5 [ RunTime:0.022544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625560 ORDER BY `minOrder` ASC [ RunTime:0.023308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625560 ORDER BY `unit` DESC [ RunTime:0.004471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625560 LIMIT 2 [ RunTime:0.013431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625560 ORDER BY `minOrder` ASC [ RunTime:0.019800s ]
select * from pdf where partno='1052345:0051' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0051' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625501 LIMIT 5 [ RunTime:0.003086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625501 ORDER BY `minOrder` ASC [ RunTime:0.002689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625501 ORDER BY `unit` DESC [ RunTime:0.006365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625501 LIMIT 2 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625501 ORDER BY `minOrder` ASC [ RunTime:0.000972s ]
select * from pdf where partno='1052345:0021' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0021' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625500 LIMIT 5 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625500 ORDER BY `minOrder` ASC [ RunTime:0.001891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625500 ORDER BY `unit` DESC [ RunTime:0.004111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625500 LIMIT 2 [ RunTime:0.053887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625500 ORDER BY `minOrder` ASC [ RunTime:0.051101s ]
select * from pdf where partno='1052345:0041' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.033789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052345:0041' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.047476s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054436s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021765s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029308s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016656s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025413s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019440s ]
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 '10523%' OR `brand` LIKE '10523%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045220s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10523%' OR `brand` LIKE '10523%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041536s ]