SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001457s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.003421s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002795s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000672s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001663s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.003838s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001991s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005033s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001901s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.014404s ]
UPDATE `stock_search` SET `count` = 2008 , `updatetime` = '2026-06-06 21:10:29' WHERE `partno` = '210' [ RunTime:0.015561s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003467s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001267s ]
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.001561s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002584s ]
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.114365s ]
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 2440,20 [ RunTime:0.053629s ]
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 ('33886951','33886950','33886948','33886939','33884453','33860820','33860806','33860785','33860757','33860755','33860743','33860705','33860699','33860645','33860072','33859599','33857311','33857226','33857192','33856626') ORDER BY FIELD(s.id, 33886951,33886950,33886948,33886939,33884453,33860820,33860806,33860785,33860757,33860755,33860743,33860705,33860699,33860645,33860072,33859599,33857311,33857226,33857192,33856626) [ RunTime:0.013526s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886951 LIMIT 4 [ RunTime:0.012460s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886951 ORDER BY `minOrder` ASC [ RunTime:0.025349s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886951 ORDER BY `unit` DESC [ RunTime:0.035493s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886951 LIMIT 2 [ RunTime:0.014109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886951 ORDER BY `minOrder` ASC [ RunTime:0.000761s ]
select * from pdf where partno='2102582-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.010179s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102582-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.007942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886950 LIMIT 4 [ RunTime:0.033800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886950 ORDER BY `minOrder` ASC [ RunTime:0.045862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886950 ORDER BY `unit` DESC [ RunTime:0.007143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886950 LIMIT 2 [ RunTime:0.005325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886950 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
select * from pdf where partno='2102575-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.005075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102575-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.013025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886948 LIMIT 4 [ RunTime:0.013042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886948 ORDER BY `minOrder` ASC [ RunTime:0.008606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886948 ORDER BY `unit` DESC [ RunTime:0.009624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886948 LIMIT 2 [ RunTime:0.003825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886948 ORDER BY `minOrder` ASC [ RunTime:0.027161s ]
select * from pdf where partno='2102579-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.004113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102579-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.016939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886939 LIMIT 4 [ RunTime:0.024253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886939 ORDER BY `minOrder` ASC [ RunTime:0.010099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886939 ORDER BY `unit` DESC [ RunTime:0.005889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886939 LIMIT 2 [ RunTime:0.010300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886939 ORDER BY `minOrder` ASC [ RunTime:0.028414s ]
select * from pdf where partno='2102571-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.017756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102571-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.014076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33884453 LIMIT 4 [ RunTime:0.030550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884453 ORDER BY `minOrder` ASC [ RunTime:0.027002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33884453 ORDER BY `unit` DESC [ RunTime:0.037699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33884453 LIMIT 2 [ RunTime:0.025684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884453 ORDER BY `minOrder` ASC [ RunTime:0.035727s ]
select * from pdf where partno='2102572-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.019261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102572-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.019573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860820 LIMIT 4 [ RunTime:0.015332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860820 ORDER BY `minOrder` ASC [ RunTime:0.028354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860820 ORDER BY `unit` DESC [ RunTime:0.037597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860820 LIMIT 2 [ RunTime:0.013233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860820 ORDER BY `minOrder` ASC [ RunTime:0.025998s ]
select * from pdf where partno='2101253-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.051177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101253-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.035510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860806 LIMIT 4 [ RunTime:0.058863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860806 ORDER BY `minOrder` ASC [ RunTime:0.111069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860806 ORDER BY `unit` DESC [ RunTime:0.114256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860806 LIMIT 2 [ RunTime:0.037741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860806 ORDER BY `minOrder` ASC [ RunTime:0.016556s ]
select * from pdf where partno='2101927-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.088268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101927-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.027820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860785 LIMIT 4 [ RunTime:0.055144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860785 ORDER BY `minOrder` ASC [ RunTime:0.081349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860785 ORDER BY `unit` DESC [ RunTime:0.061372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860785 LIMIT 2 [ RunTime:0.031930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860785 ORDER BY `minOrder` ASC [ RunTime:0.026181s ]
select * from pdf where partno='2101423-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.029711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101423-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.039921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860757 LIMIT 4 [ RunTime:0.048423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860757 ORDER BY `minOrder` ASC [ RunTime:0.034380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860757 ORDER BY `unit` DESC [ RunTime:0.032739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860757 LIMIT 2 [ RunTime:0.020564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860757 ORDER BY `minOrder` ASC [ RunTime:0.032739s ]
select * from pdf where partno='2101650-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.025414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101650-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.080595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860755 LIMIT 4 [ RunTime:0.036015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860755 ORDER BY `minOrder` ASC [ RunTime:0.096257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860755 ORDER BY `unit` DESC [ RunTime:0.064003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860755 LIMIT 2 [ RunTime:0.050843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860755 ORDER BY `minOrder` ASC [ RunTime:0.043746s ]
select * from pdf where partno='2101598-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.025270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101598-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.047509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860743 LIMIT 4 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860743 ORDER BY `minOrder` ASC [ RunTime:0.024018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860743 ORDER BY `unit` DESC [ RunTime:0.019645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860743 LIMIT 2 [ RunTime:0.025858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860743 ORDER BY `minOrder` ASC [ RunTime:0.009298s ]
select * from pdf where partno='2101252-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.074942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101252-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.021636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860705 LIMIT 4 [ RunTime:0.020994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860705 ORDER BY `minOrder` ASC [ RunTime:0.090473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860705 ORDER BY `unit` DESC [ RunTime:0.033176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860705 LIMIT 2 [ RunTime:0.019307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860705 ORDER BY `minOrder` ASC [ RunTime:0.076604s ]
select * from pdf where partno='2101003-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101003-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.031919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860699 LIMIT 4 [ RunTime:0.025009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860699 ORDER BY `minOrder` ASC [ RunTime:0.071949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860699 ORDER BY `unit` DESC [ RunTime:0.017937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860699 LIMIT 2 [ RunTime:0.016831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860699 ORDER BY `minOrder` ASC [ RunTime:0.051451s ]
select * from pdf where partno='2101002-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101002-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.070017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860645 LIMIT 4 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860645 ORDER BY `minOrder` ASC [ RunTime:0.116200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860645 ORDER BY `unit` DESC [ RunTime:0.079270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860645 LIMIT 2 [ RunTime:0.026109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860645 ORDER BY `minOrder` ASC [ RunTime:0.022242s ]
select * from pdf where partno='2101004-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.037946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101004-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860072 LIMIT 4 [ RunTime:0.073173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860072 ORDER BY `minOrder` ASC [ RunTime:0.116499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860072 ORDER BY `unit` DESC [ RunTime:0.120845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860072 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860072 ORDER BY `minOrder` ASC [ RunTime:0.074963s ]
select * from pdf where partno='2101300-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101300-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33859599 LIMIT 4 [ RunTime:0.012350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33859599 ORDER BY `minOrder` ASC [ RunTime:0.081587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33859599 ORDER BY `unit` DESC [ RunTime:0.015365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33859599 LIMIT 2 [ RunTime:0.002602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33859599 ORDER BY `minOrder` ASC [ RunTime:0.043633s ]
select * from pdf where partno='2107.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.019989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.002070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857311 LIMIT 4 [ RunTime:0.015569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857311 ORDER BY `minOrder` ASC [ RunTime:0.045854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857311 ORDER BY `unit` DESC [ RunTime:0.051850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857311 LIMIT 2 [ RunTime:0.026314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857311 ORDER BY `minOrder` ASC [ RunTime:0.018894s ]
select * from pdf where partno='2106.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.005531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.004866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857226 LIMIT 4 [ RunTime:0.030534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857226 ORDER BY `minOrder` ASC [ RunTime:0.065243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857226 ORDER BY `unit` DESC [ RunTime:0.038966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857226 LIMIT 2 [ RunTime:0.044072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857226 ORDER BY `minOrder` ASC [ RunTime:0.020509s ]
select * from pdf where partno='2109.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.038204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.036497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857192 LIMIT 4 [ RunTime:0.031550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857192 ORDER BY `minOrder` ASC [ RunTime:0.054628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857192 ORDER BY `unit` DESC [ RunTime:0.026868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857192 LIMIT 2 [ RunTime:0.028992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857192 ORDER BY `minOrder` ASC [ RunTime:0.067741s ]
select * from pdf where partno='2108.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.049781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.054349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33856626 LIMIT 4 [ RunTime:0.035621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33856626 ORDER BY `minOrder` ASC [ RunTime:0.042158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33856626 ORDER BY `unit` DESC [ RunTime:0.018831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33856626 LIMIT 2 [ RunTime:0.022984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33856626 ORDER BY `minOrder` ASC [ RunTime:0.020613s ]
select * from pdf where partno='2108870000' and brandshort='Weidmüller' limit 1 [ RunTime:0.026324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108870000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.012893s ]
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.021977s ]