SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001441s ]
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=251&srecordnum=7527' [ RunTime:0.002449s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001286s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001955s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.005067s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001148s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003293s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001423s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005087s ]
UPDATE `stock_search` SET `count` = 5345 , `updatetime` = '2026-06-08 22:52:04' WHERE `partno` = '210' [ RunTime:0.013887s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002667s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000236s ]
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.003091s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001253s ]
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.085408s ]
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 5000,20 [ RunTime:0.078842s ]
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 ('33311360','33309522','33308673','33308631','33308170','33307785','33307736','33307719','33307697','33307696','33307695','33307483','33307118','33306738','33304525','33304372','33174799','33172084','33171805','33171217') ORDER BY FIELD(s.id, 33311360,33309522,33308673,33308631,33308170,33307785,33307736,33307719,33307697,33307696,33307695,33307483,33307118,33306738,33304525,33304372,33174799,33172084,33171805,33171217) [ RunTime:0.003022s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33311360 LIMIT 4 [ RunTime:0.000613s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33311360 ORDER BY `minOrder` ASC [ RunTime:0.005182s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33311360 ORDER BY `unit` DESC [ RunTime:0.004423s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33311360 LIMIT 2 [ RunTime:0.007154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33311360 ORDER BY `minOrder` ASC [ RunTime:0.010226s ]
select * from pdf where partno='210-297' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001168s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-297' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33309522 LIMIT 4 [ RunTime:0.010133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33309522 ORDER BY `minOrder` ASC [ RunTime:0.005586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33309522 ORDER BY `unit` DESC [ RunTime:0.004174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33309522 LIMIT 2 [ RunTime:0.007491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33309522 ORDER BY `minOrder` ASC [ RunTime:0.005331s ]
select * from pdf where partno='210-281' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-281' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.006571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33308673 LIMIT 4 [ RunTime:0.007592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308673 ORDER BY `minOrder` ASC [ RunTime:0.006028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33308673 ORDER BY `unit` DESC [ RunTime:0.002933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33308673 LIMIT 2 [ RunTime:0.008349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308673 ORDER BY `minOrder` ASC [ RunTime:0.008071s ]
select * from pdf where partno='2105.5' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.001780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105.5' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33308631 LIMIT 4 [ RunTime:0.006574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308631 ORDER BY `minOrder` ASC [ RunTime:0.008059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33308631 ORDER BY `unit` DESC [ RunTime:0.001832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33308631 LIMIT 2 [ RunTime:0.008453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308631 ORDER BY `minOrder` ASC [ RunTime:0.012521s ]
select * from pdf where partno='2105.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33308170 LIMIT 4 [ RunTime:0.010938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308170 ORDER BY `minOrder` ASC [ RunTime:0.007512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33308170 ORDER BY `unit` DESC [ RunTime:0.000723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33308170 LIMIT 2 [ RunTime:0.003666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33308170 ORDER BY `minOrder` ASC [ RunTime:0.002352s ]
select * from pdf where partno='2101.3' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.004059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.3' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.001082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307785 LIMIT 4 [ RunTime:0.006950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307785 ORDER BY `minOrder` ASC [ RunTime:0.003320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307785 ORDER BY `unit` DESC [ RunTime:0.003602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307785 LIMIT 2 [ RunTime:0.005019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307785 ORDER BY `minOrder` ASC [ RunTime:0.006960s ]
select * from pdf where partno='2104.5' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.003396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104.5' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.005636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307736 LIMIT 4 [ RunTime:0.004357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307736 ORDER BY `minOrder` ASC [ RunTime:0.007374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307736 ORDER BY `unit` DESC [ RunTime:0.001013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307736 LIMIT 2 [ RunTime:0.007319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307736 ORDER BY `minOrder` ASC [ RunTime:0.003612s ]
select * from pdf where partno='210-549' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-549' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307719 LIMIT 4 [ RunTime:0.006326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307719 ORDER BY `minOrder` ASC [ RunTime:0.004700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307719 ORDER BY `unit` DESC [ RunTime:0.000787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307719 LIMIT 2 [ RunTime:0.006359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307719 ORDER BY `minOrder` ASC [ RunTime:0.004972s ]
select * from pdf where partno='2104.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.005000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.001658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307697 LIMIT 4 [ RunTime:0.008523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307697 ORDER BY `minOrder` ASC [ RunTime:0.009921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307697 ORDER BY `unit` DESC [ RunTime:0.003697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307697 LIMIT 2 [ RunTime:0.003152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307697 ORDER BY `minOrder` ASC [ RunTime:0.005410s ]
select * from pdf where partno='2101.8' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.004503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.8' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.002018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307696 LIMIT 4 [ RunTime:0.004138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307696 ORDER BY `minOrder` ASC [ RunTime:0.002758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307696 ORDER BY `unit` DESC [ RunTime:0.003071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307696 LIMIT 2 [ RunTime:0.004425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307696 ORDER BY `minOrder` ASC [ RunTime:0.001691s ]
select * from pdf where partno='2101.5' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.003981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.5' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307695 LIMIT 4 [ RunTime:0.002483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307695 ORDER BY `minOrder` ASC [ RunTime:0.001824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307695 ORDER BY `unit` DESC [ RunTime:0.003954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307695 LIMIT 2 [ RunTime:0.004140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307695 ORDER BY `minOrder` ASC [ RunTime:0.003303s ]
select * from pdf where partno='2101.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.002302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.001467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307483 LIMIT 4 [ RunTime:0.004922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307483 ORDER BY `minOrder` ASC [ RunTime:0.002308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307483 ORDER BY `unit` DESC [ RunTime:0.001365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307483 LIMIT 2 [ RunTime:0.002445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307483 ORDER BY `minOrder` ASC [ RunTime:0.001547s ]
select * from pdf where partno='2104.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.007369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.003222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33307118 LIMIT 4 [ RunTime:0.002390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307118 ORDER BY `minOrder` ASC [ RunTime:0.002246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33307118 ORDER BY `unit` DESC [ RunTime:0.005755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33307118 LIMIT 2 [ RunTime:0.007585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33307118 ORDER BY `minOrder` ASC [ RunTime:0.015331s ]
select * from pdf where partno='2101.2' and brandshort='On Shore Technology Inc.' limit 1 [ RunTime:0.005015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.2' OR `brand` LIKE 'On Shore Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.001387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33306738 LIMIT 4 [ RunTime:0.002637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33306738 ORDER BY `minOrder` ASC [ RunTime:0.002759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33306738 ORDER BY `unit` DESC [ RunTime:0.003463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33306738 LIMIT 2 [ RunTime:0.011214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33306738 ORDER BY `minOrder` ASC [ RunTime:0.002870s ]
select * from pdf where partno='2104.2' and brandshort='On Shore Technology Inc.' limit 1 [ RunTime:0.001094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104.2' OR `brand` LIKE 'On Shore Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.001225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33304525 LIMIT 4 [ RunTime:0.005200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304525 ORDER BY `minOrder` ASC [ RunTime:0.003576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33304525 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33304525 LIMIT 2 [ RunTime:0.002057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304525 ORDER BY `minOrder` ASC [ RunTime:0.003970s ]
select * from pdf where partno='2101.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.001739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33304372 LIMIT 4 [ RunTime:0.004197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304372 ORDER BY `minOrder` ASC [ RunTime:0.001521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33304372 ORDER BY `unit` DESC [ RunTime:0.004514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33304372 LIMIT 2 [ RunTime:0.001309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304372 ORDER BY `minOrder` ASC [ RunTime:0.000984s ]
select * from pdf where partno='2102-1392' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-1392' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33174799 LIMIT 4 [ RunTime:0.001761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33174799 ORDER BY `minOrder` ASC [ RunTime:0.001180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33174799 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33174799 LIMIT 2 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33174799 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
select * from pdf where partno='2100-0065' and brandshort='Metcal' limit 1 [ RunTime:0.001274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-0065' OR `brand` LIKE 'Metcal%' ) ) LIMIT 1 [ RunTime:0.000861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33172084 LIMIT 4 [ RunTime:0.001527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33172084 ORDER BY `minOrder` ASC [ RunTime:0.001428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33172084 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33172084 LIMIT 2 [ RunTime:0.000906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33172084 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
select * from pdf where partno='21094' and brandshort='Wiha' limit 1 [ RunTime:0.001025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21094' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.003385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171805 LIMIT 4 [ RunTime:0.003418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171805 ORDER BY `minOrder` ASC [ RunTime:0.007565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171805 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171805 LIMIT 2 [ RunTime:0.001557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171805 ORDER BY `minOrder` ASC [ RunTime:0.000838s ]
select * from pdf where partno='21095' and brandshort='Wiha' limit 1 [ RunTime:0.001263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21095' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.002908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171217 LIMIT 4 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171217 ORDER BY `minOrder` ASC [ RunTime:0.001333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171217 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171217 LIMIT 2 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171217 ORDER BY `minOrder` ASC [ RunTime:0.000864s ]
select * from pdf where partno='21032' and brandshort='Wiha' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.001747s ]
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.067887s ]