SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002353s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=232&srecordnum=7365' [ RunTime:0.005120s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002940s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001673s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001470s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.005801s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001104s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003725s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000990s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.008636s ]
UPDATE `stock_search` SET `count` = 4504 , `updatetime` = '2026-06-08 18:30:42' WHERE `partno` = '210' [ RunTime:0.006542s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000892s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000191s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.001925s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002308s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000384s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 4620,20 [ RunTime:0.042480s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('33854767','33854766','33854765','33854764','33854763','33854762','33854761','33854760','33854759','33854758','33854757','33854756','33854755','33854754','33854753','33854752','33854751','33854750','33854749','33854648') ORDER BY FIELD(s.id, 33854767,33854766,33854765,33854764,33854763,33854762,33854761,33854760,33854759,33854758,33854757,33854756,33854755,33854754,33854753,33854752,33854751,33854750,33854749,33854648) [ RunTime:0.005782s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854767 LIMIT 4 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854767 ORDER BY `minOrder` ASC [ RunTime:0.009688s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854767 ORDER BY `unit` DESC [ RunTime:0.006253s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854767 LIMIT 2 [ RunTime:0.003510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854767 ORDER BY `minOrder` ASC [ RunTime:0.005160s ]
select * from pdf where partno='210-331/508-020' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001381s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-331/508-020' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854766 LIMIT 4 [ RunTime:0.002924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854766 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854766 ORDER BY `unit` DESC [ RunTime:0.000942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854766 LIMIT 2 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854766 ORDER BY `minOrder` ASC [ RunTime:0.003020s ]
select * from pdf where partno='210-332/635-087' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/635-087' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854765 LIMIT 4 [ RunTime:0.010198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854765 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854765 ORDER BY `unit` DESC [ RunTime:0.004880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854765 LIMIT 2 [ RunTime:0.004946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854765 ORDER BY `minOrder` ASC [ RunTime:0.008168s ]
select * from pdf where partno='210-333/600-074' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/600-074' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854764 LIMIT 4 [ RunTime:0.002342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854764 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854764 ORDER BY `unit` DESC [ RunTime:0.003102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854764 LIMIT 2 [ RunTime:0.007618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854764 ORDER BY `minOrder` ASC [ RunTime:0.002620s ]
select * from pdf where partno='210-333/500-002' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/500-002' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854763 LIMIT 4 [ RunTime:0.033611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854763 ORDER BY `minOrder` ASC [ RunTime:0.012891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854763 ORDER BY `unit` DESC [ RunTime:0.002687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854763 LIMIT 2 [ RunTime:0.002624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854763 ORDER BY `minOrder` ASC [ RunTime:0.004660s ]
select * from pdf where partno='210-333/800-076' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.009016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-076' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854762 LIMIT 4 [ RunTime:0.006784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854762 ORDER BY `minOrder` ASC [ RunTime:0.010242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854762 ORDER BY `unit` DESC [ RunTime:0.001952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854762 LIMIT 2 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854762 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='210-333/800-009' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-009' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854761 LIMIT 4 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854761 ORDER BY `minOrder` ASC [ RunTime:0.003800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854761 ORDER BY `unit` DESC [ RunTime:0.012881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854761 LIMIT 2 [ RunTime:0.024073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854761 ORDER BY `minOrder` ASC [ RunTime:0.007856s ]
select * from pdf where partno='210-333/800-006' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.036797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-006' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854760 LIMIT 4 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854760 ORDER BY `minOrder` ASC [ RunTime:0.012171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854760 ORDER BY `unit` DESC [ RunTime:0.017605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854760 LIMIT 2 [ RunTime:0.011219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854760 ORDER BY `minOrder` ASC [ RunTime:0.002754s ]
select * from pdf where partno='210-333/700-020' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/700-020' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854759 LIMIT 4 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854759 ORDER BY `minOrder` ASC [ RunTime:0.001050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854759 ORDER BY `unit` DESC [ RunTime:0.017116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854759 LIMIT 2 [ RunTime:0.015282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854759 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
select * from pdf where partno='210-333/500-006' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/500-006' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854758 LIMIT 4 [ RunTime:0.007818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854758 ORDER BY `minOrder` ASC [ RunTime:0.008863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854758 ORDER BY `unit` DESC [ RunTime:0.021674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854758 LIMIT 2 [ RunTime:0.008575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854758 ORDER BY `minOrder` ASC [ RunTime:0.002768s ]
select * from pdf where partno='210-331/250-207' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-331/250-207' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854757 LIMIT 4 [ RunTime:0.012527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854757 ORDER BY `minOrder` ASC [ RunTime:0.016104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854757 ORDER BY `unit` DESC [ RunTime:0.009884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854757 LIMIT 2 [ RunTime:0.026908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854757 ORDER BY `minOrder` ASC [ RunTime:0.004546s ]
select * from pdf where partno='210-333/1000-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.017242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1000-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.025646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854756 LIMIT 4 [ RunTime:0.029880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854756 ORDER BY `minOrder` ASC [ RunTime:0.017452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854756 ORDER BY `unit` DESC [ RunTime:0.002947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854756 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854756 ORDER BY `minOrder` ASC [ RunTime:0.007512s ]
select * from pdf where partno='210-333/800-002' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.029599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-002' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854755 LIMIT 4 [ RunTime:0.002403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854755 ORDER BY `minOrder` ASC [ RunTime:0.001841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854755 ORDER BY `unit` DESC [ RunTime:0.007575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854755 LIMIT 2 [ RunTime:0.018805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854755 ORDER BY `minOrder` ASC [ RunTime:0.001609s ]
select * from pdf where partno='210-332/635-200' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/635-200' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854754 LIMIT 4 [ RunTime:0.026400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854754 ORDER BY `minOrder` ASC [ RunTime:0.013713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854754 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854754 LIMIT 2 [ RunTime:0.004587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854754 ORDER BY `minOrder` ASC [ RunTime:0.004732s ]
select * from pdf where partno='210-332/1016-202' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/1016-202' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854753 LIMIT 4 [ RunTime:0.006550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854753 ORDER BY `minOrder` ASC [ RunTime:0.019636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854753 ORDER BY `unit` DESC [ RunTime:0.004593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854753 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854753 ORDER BY `minOrder` ASC [ RunTime:0.003158s ]
select * from pdf where partno='210-333/600-006' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.005185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/600-006' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854752 LIMIT 4 [ RunTime:0.006931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854752 ORDER BY `minOrder` ASC [ RunTime:0.007609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854752 ORDER BY `unit` DESC [ RunTime:0.004061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854752 LIMIT 2 [ RunTime:0.013302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854752 ORDER BY `minOrder` ASC [ RunTime:0.004176s ]
select * from pdf where partno='210-333/500-009' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/500-009' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854751 LIMIT 4 [ RunTime:0.002646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854751 ORDER BY `minOrder` ASC [ RunTime:0.009863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854751 ORDER BY `unit` DESC [ RunTime:0.000809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854751 LIMIT 2 [ RunTime:0.016489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854751 ORDER BY `minOrder` ASC [ RunTime:0.004316s ]
select * from pdf where partno='210-333/700-075' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/700-075' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.024395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854750 LIMIT 4 [ RunTime:0.015701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854750 ORDER BY `minOrder` ASC [ RunTime:0.003723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854750 ORDER BY `unit` DESC [ RunTime:0.020473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854750 LIMIT 2 [ RunTime:0.016089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854750 ORDER BY `minOrder` ASC [ RunTime:0.006586s ]
select * from pdf where partno='210-333/1000-206' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1000-206' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.017414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854749 LIMIT 4 [ RunTime:0.016844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854749 ORDER BY `minOrder` ASC [ RunTime:0.009564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854749 ORDER BY `unit` DESC [ RunTime:0.015288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854749 LIMIT 2 [ RunTime:0.010166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854749 ORDER BY `minOrder` ASC [ RunTime:0.003532s ]
select * from pdf where partno='210-331/762-202' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.014326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-331/762-202' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854648 LIMIT 4 [ RunTime:0.004049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854648 ORDER BY `minOrder` ASC [ RunTime:0.002323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854648 ORDER BY `unit` DESC [ RunTime:0.000740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854648 LIMIT 2 [ RunTime:0.003395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854648 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='210-333/1200-103' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1200-103' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003858s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000593s ]