SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001611s ]
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.007747s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001898s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006929s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001615s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.010882s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002450s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009677s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001307s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.018840s ]
UPDATE `stock_search` SET `count` = 2004 , `updatetime` = '2026-06-06 21:09:59' WHERE `partno` = '210' [ RunTime:0.014802s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.009077s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.014571s ]
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.006402s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001313s ]
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.013487s ]
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.098278s ]
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.056436s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.036549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886951 LIMIT 4 [ RunTime:0.139037s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886951 ORDER BY `minOrder` ASC [ RunTime:0.044535s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886951 ORDER BY `unit` DESC [ RunTime:0.144930s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886951 LIMIT 2 [ RunTime:0.107684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886951 ORDER BY `minOrder` ASC [ RunTime:0.051284s ]
select * from pdf where partno='2102582-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.039123s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102582-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.087232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886950 LIMIT 4 [ RunTime:0.199810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886950 ORDER BY `minOrder` ASC [ RunTime:0.078435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886950 ORDER BY `unit` DESC [ RunTime:0.080008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886950 LIMIT 2 [ RunTime:0.161340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886950 ORDER BY `minOrder` ASC [ RunTime:0.058874s ]
select * from pdf where partno='2102575-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.043476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102575-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.052327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886948 LIMIT 4 [ RunTime:0.108826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886948 ORDER BY `minOrder` ASC [ RunTime:0.112426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886948 ORDER BY `unit` DESC [ RunTime:0.148389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886948 LIMIT 2 [ RunTime:0.067697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886948 ORDER BY `minOrder` ASC [ RunTime:0.030164s ]
select * from pdf where partno='2102579-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.016496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102579-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.058439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886939 LIMIT 4 [ RunTime:0.136563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886939 ORDER BY `minOrder` ASC [ RunTime:0.037463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886939 ORDER BY `unit` DESC [ RunTime:0.121757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886939 LIMIT 2 [ RunTime:0.131741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886939 ORDER BY `minOrder` ASC [ RunTime:0.059299s ]
select * from pdf where partno='2102571-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.050119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102571-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.051506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33884453 LIMIT 4 [ RunTime:0.128698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884453 ORDER BY `minOrder` ASC [ RunTime:0.052211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33884453 ORDER BY `unit` DESC [ RunTime:0.062310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33884453 LIMIT 2 [ RunTime:0.029537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884453 ORDER BY `minOrder` ASC [ RunTime:0.032489s ]
select * from pdf where partno='2102572-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.044276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102572-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.039276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860820 LIMIT 4 [ RunTime:0.041293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860820 ORDER BY `minOrder` ASC [ RunTime:0.132034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860820 ORDER BY `unit` DESC [ RunTime:0.040668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860820 LIMIT 2 [ RunTime:0.046960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860820 ORDER BY `minOrder` ASC [ RunTime:0.085044s ]
select * from pdf where partno='2101253-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.051212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101253-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.051120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860806 LIMIT 4 [ RunTime:0.050814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860806 ORDER BY `minOrder` ASC [ RunTime:0.051073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860806 ORDER BY `unit` DESC [ RunTime:0.050825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860806 LIMIT 2 [ RunTime:0.024641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860806 ORDER BY `minOrder` ASC [ RunTime:0.082841s ]
select * from pdf where partno='2101927-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.081021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101927-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.149379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860785 LIMIT 4 [ RunTime:0.130738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860785 ORDER BY `minOrder` ASC [ RunTime:0.105795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860785 ORDER BY `unit` DESC [ RunTime:0.037509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860785 LIMIT 2 [ RunTime:0.115303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860785 ORDER BY `minOrder` ASC [ RunTime:0.056813s ]
select * from pdf where partno='2101423-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.107524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101423-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.144567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860757 LIMIT 4 [ RunTime:0.071006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860757 ORDER BY `minOrder` ASC [ RunTime:0.057552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860757 ORDER BY `unit` DESC [ RunTime:0.085250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860757 LIMIT 2 [ RunTime:0.079588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860757 ORDER BY `minOrder` ASC [ RunTime:0.046411s ]
select * from pdf where partno='2101650-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.033310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101650-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.075285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860755 LIMIT 4 [ RunTime:0.030265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860755 ORDER BY `minOrder` ASC [ RunTime:0.024078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860755 ORDER BY `unit` DESC [ RunTime:0.014789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860755 LIMIT 2 [ RunTime:0.100043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860755 ORDER BY `minOrder` ASC [ RunTime:0.141424s ]
select * from pdf where partno='2101598-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.050131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101598-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.064899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860743 LIMIT 4 [ RunTime:0.047630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860743 ORDER BY `minOrder` ASC [ RunTime:0.024915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860743 ORDER BY `unit` DESC [ RunTime:0.047706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860743 LIMIT 2 [ RunTime:0.050550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860743 ORDER BY `minOrder` ASC [ RunTime:0.024153s ]
select * from pdf where partno='2101252-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101252-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.032414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860705 LIMIT 4 [ RunTime:0.043215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860705 ORDER BY `minOrder` ASC [ RunTime:0.005754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860705 ORDER BY `unit` DESC [ RunTime:0.014720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860705 LIMIT 2 [ RunTime:0.017020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860705 ORDER BY `minOrder` ASC [ RunTime:0.008947s ]
select * from pdf where partno='2101003-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101003-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860699 LIMIT 4 [ RunTime:0.015950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860699 ORDER BY `minOrder` ASC [ RunTime:0.004134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860699 ORDER BY `unit` DESC [ RunTime:0.001976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860699 LIMIT 2 [ RunTime:0.009536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860699 ORDER BY `minOrder` ASC [ RunTime:0.009266s ]
select * from pdf where partno='2101002-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101002-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.022199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860645 LIMIT 4 [ RunTime:0.014647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860645 ORDER BY `minOrder` ASC [ RunTime:0.008000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860645 ORDER BY `unit` DESC [ RunTime:0.008898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860645 LIMIT 2 [ RunTime:0.010918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860645 ORDER BY `minOrder` ASC [ RunTime:0.023386s ]
select * from pdf where partno='2101004-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101004-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860072 LIMIT 4 [ RunTime:0.008088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860072 ORDER BY `minOrder` ASC [ RunTime:0.003543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860072 ORDER BY `unit` DESC [ RunTime:0.006153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860072 LIMIT 2 [ RunTime:0.009686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860072 ORDER BY `minOrder` ASC [ RunTime:0.008438s ]
select * from pdf where partno='2101300-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101300-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33859599 LIMIT 4 [ RunTime:0.007446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33859599 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33859599 ORDER BY `unit` DESC [ RunTime:0.009506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33859599 LIMIT 2 [ RunTime:0.007663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33859599 ORDER BY `minOrder` ASC [ RunTime:0.014859s ]
select * from pdf where partno='2107.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.030316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.008893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857311 LIMIT 4 [ RunTime:0.012870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857311 ORDER BY `minOrder` ASC [ RunTime:0.009410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857311 ORDER BY `unit` DESC [ RunTime:0.011829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857311 LIMIT 2 [ RunTime:0.018534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857311 ORDER BY `minOrder` ASC [ RunTime:0.015320s ]
select * from pdf where partno='2106.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.018043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857226 LIMIT 4 [ RunTime:0.016662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857226 ORDER BY `minOrder` ASC [ RunTime:0.029292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857226 ORDER BY `unit` DESC [ RunTime:0.009914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857226 LIMIT 2 [ RunTime:0.014456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857226 ORDER BY `minOrder` ASC [ RunTime:0.014701s ]
select * from pdf where partno='2109.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.017385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.012740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857192 LIMIT 4 [ RunTime:0.002466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857192 ORDER BY `minOrder` ASC [ RunTime:0.003104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857192 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857192 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857192 ORDER BY `minOrder` ASC [ RunTime:0.000762s ]
select * from pdf where partno='2108.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.003455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.004583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33856626 LIMIT 4 [ RunTime:0.002603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33856626 ORDER BY `minOrder` ASC [ RunTime:0.001510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33856626 ORDER BY `unit` DESC [ RunTime:0.000761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33856626 LIMIT 2 [ RunTime:0.000990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33856626 ORDER BY `minOrder` ASC [ RunTime:0.000831s ]
select * from pdf where partno='2108870000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108870000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006078s ]
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.050717s ]