SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001572s ]
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.002046s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001525s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000548s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001602s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.001109s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001600s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001409s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004248s ]
UPDATE `stock_search` SET `count` = 1860 , `updatetime` = '2026-06-06 20:02:47' WHERE `partno` = '210' [ RunTime:0.003214s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000265s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000237s ]
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.000408s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002439s ]
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.174302s ]
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.132363s ]
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.028478s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886951 LIMIT 4 [ RunTime:0.009678s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886951 ORDER BY `minOrder` ASC [ RunTime:0.036654s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886951 ORDER BY `unit` DESC [ RunTime:0.022131s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886951 LIMIT 2 [ RunTime:0.032576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886951 ORDER BY `minOrder` ASC [ RunTime:0.017021s ]
select * from pdf where partno='2102582-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.024207s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102582-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.041123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886950 LIMIT 4 [ RunTime:0.039482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886950 ORDER BY `minOrder` ASC [ RunTime:0.034831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886950 ORDER BY `unit` DESC [ RunTime:0.033441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886950 LIMIT 2 [ RunTime:0.034259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886950 ORDER BY `minOrder` ASC [ RunTime:0.009502s ]
select * from pdf where partno='2102575-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.032263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102575-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.054168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886948 LIMIT 4 [ RunTime:0.106303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886948 ORDER BY `minOrder` ASC [ RunTime:0.031997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886948 ORDER BY `unit` DESC [ RunTime:0.056437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886948 LIMIT 2 [ RunTime:0.044213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886948 ORDER BY `minOrder` ASC [ RunTime:0.005469s ]
select * from pdf where partno='2102579-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.043391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102579-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.077412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886939 LIMIT 4 [ RunTime:0.036395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886939 ORDER BY `minOrder` ASC [ RunTime:0.104605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886939 ORDER BY `unit` DESC [ RunTime:0.068332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886939 LIMIT 2 [ RunTime:0.035496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886939 ORDER BY `minOrder` ASC [ RunTime:0.010342s ]
select * from pdf where partno='2102571-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.037862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102571-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.018650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33884453 LIMIT 4 [ RunTime:0.037575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884453 ORDER BY `minOrder` ASC [ RunTime:0.029717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33884453 ORDER BY `unit` DESC [ RunTime:0.038925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33884453 LIMIT 2 [ RunTime:0.022077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884453 ORDER BY `minOrder` ASC [ RunTime:0.039998s ]
select * from pdf where partno='2102572-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.115598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102572-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.032839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860820 LIMIT 4 [ RunTime:0.027010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860820 ORDER BY `minOrder` ASC [ RunTime:0.074967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860820 ORDER BY `unit` DESC [ RunTime:0.053935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860820 LIMIT 2 [ RunTime:0.060246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860820 ORDER BY `minOrder` ASC [ RunTime:0.002199s ]
select * from pdf where partno='2101253-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.051456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101253-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.075472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860806 LIMIT 4 [ RunTime:0.056077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860806 ORDER BY `minOrder` ASC [ RunTime:0.032233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860806 ORDER BY `unit` DESC [ RunTime:0.064542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860806 LIMIT 2 [ RunTime:0.059886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860806 ORDER BY `minOrder` ASC [ RunTime:0.016622s ]
select * from pdf where partno='2101927-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101927-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.074503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860785 LIMIT 4 [ RunTime:0.057186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860785 ORDER BY `minOrder` ASC [ RunTime:0.022252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860785 ORDER BY `unit` DESC [ RunTime:0.016531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860785 LIMIT 2 [ RunTime:0.023502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860785 ORDER BY `minOrder` ASC [ RunTime:0.022470s ]
select * from pdf where partno='2101423-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101423-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860757 LIMIT 4 [ RunTime:0.019674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860757 ORDER BY `minOrder` ASC [ RunTime:0.012919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860757 ORDER BY `unit` DESC [ RunTime:0.012138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860757 LIMIT 2 [ RunTime:0.015072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860757 ORDER BY `minOrder` ASC [ RunTime:0.017597s ]
select * from pdf where partno='2101650-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101650-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860755 LIMIT 4 [ RunTime:0.030348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860755 ORDER BY `minOrder` ASC [ RunTime:0.008598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860755 ORDER BY `unit` DESC [ RunTime:0.005694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860755 LIMIT 2 [ RunTime:0.020952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860755 ORDER BY `minOrder` ASC [ RunTime:0.011277s ]
select * from pdf where partno='2101598-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.003474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101598-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.008335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860743 LIMIT 4 [ RunTime:0.006183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860743 ORDER BY `minOrder` ASC [ RunTime:0.013966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860743 ORDER BY `unit` DESC [ RunTime:0.035137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860743 LIMIT 2 [ RunTime:0.017759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860743 ORDER BY `minOrder` ASC [ RunTime:0.009061s ]
select * from pdf where partno='2101252-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101252-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860705 LIMIT 4 [ RunTime:0.017088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860705 ORDER BY `minOrder` ASC [ RunTime:0.009892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860705 ORDER BY `unit` DESC [ RunTime:0.012651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860705 LIMIT 2 [ RunTime:0.005467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860705 ORDER BY `minOrder` ASC [ RunTime:0.019236s ]
select * from pdf where partno='2101003-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.025021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101003-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860699 LIMIT 4 [ RunTime:0.016984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860699 ORDER BY `minOrder` ASC [ RunTime:0.015219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860699 ORDER BY `unit` DESC [ RunTime:0.010603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860699 LIMIT 2 [ RunTime:0.028875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860699 ORDER BY `minOrder` ASC [ RunTime:0.001376s ]
select * from pdf where partno='2101002-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.031880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101002-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.023532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860645 LIMIT 4 [ RunTime:0.035827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860645 ORDER BY `minOrder` ASC [ RunTime:0.008233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860645 ORDER BY `unit` DESC [ RunTime:0.025380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860645 LIMIT 2 [ RunTime:0.015304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860645 ORDER BY `minOrder` ASC [ RunTime:0.036505s ]
select * from pdf where partno='2101004-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101004-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860072 LIMIT 4 [ RunTime:0.090167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860072 ORDER BY `minOrder` ASC [ RunTime:0.059868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860072 ORDER BY `unit` DESC [ RunTime:0.028145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860072 LIMIT 2 [ RunTime:0.020390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860072 ORDER BY `minOrder` ASC [ RunTime:0.010898s ]
select * from pdf where partno='2101300-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.029502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101300-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.044655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33859599 LIMIT 4 [ RunTime:0.023480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33859599 ORDER BY `minOrder` ASC [ RunTime:0.026418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33859599 ORDER BY `unit` DESC [ RunTime:0.006692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33859599 LIMIT 2 [ RunTime:0.004177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33859599 ORDER BY `minOrder` ASC [ RunTime:0.005833s ]
select * from pdf where partno='2107.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.027050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.027595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857311 LIMIT 4 [ RunTime:0.030213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857311 ORDER BY `minOrder` ASC [ RunTime:0.008697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857311 ORDER BY `unit` DESC [ RunTime:0.006818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857311 LIMIT 2 [ RunTime:0.007412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857311 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='2106.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.003355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.004622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857226 LIMIT 4 [ RunTime:0.005400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857226 ORDER BY `minOrder` ASC [ RunTime:0.010930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857226 ORDER BY `unit` DESC [ RunTime:0.001965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857226 LIMIT 2 [ RunTime:0.014740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857226 ORDER BY `minOrder` ASC [ RunTime:0.008799s ]
select * from pdf where partno='2109.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.003328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.007771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33857192 LIMIT 4 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857192 ORDER BY `minOrder` ASC [ RunTime:0.001930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33857192 ORDER BY `unit` DESC [ RunTime:0.003954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33857192 LIMIT 2 [ RunTime:0.007162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33857192 ORDER BY `minOrder` ASC [ RunTime:0.001820s ]
select * from pdf where partno='2108.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.007068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.001862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33856626 LIMIT 4 [ RunTime:0.007523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33856626 ORDER BY `minOrder` ASC [ RunTime:0.004002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33856626 ORDER BY `unit` DESC [ RunTime:0.001208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33856626 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33856626 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
select * from pdf where partno='2108870000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108870000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.016537s ]
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.000338s ]