SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002689s ]
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` = '' [ RunTime:0.003827s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001376s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004754s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001568s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.001891s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.005683s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005433s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001522s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.016124s ]
UPDATE `stock_search` SET `count` = 4125 , `updatetime` = '2026-06-08 16:47:22' WHERE `partno` = '210' [ RunTime:0.022606s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.006391s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002362s ]
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.003624s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002234s ]
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.005792s ]
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 4200,20 [ RunTime:0.068337s ]
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 ('35279249','35278440','35278099','35273458','35272369','35272042','35268440','35207255','34887822','34759722','34757008','34706020','34644264','34625360','34594407','34565897','34564854','34556855','34552885','34545451') ORDER BY FIELD(s.id, 35279249,35278440,35278099,35273458,35272369,35272042,35268440,35207255,34887822,34759722,34757008,34706020,34644264,34625360,34594407,34565897,34564854,34556855,34552885,34545451) [ RunTime:0.054543s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.020461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35279249 LIMIT 4 [ RunTime:0.073734s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35279249 ORDER BY `minOrder` ASC [ RunTime:0.046691s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35279249 ORDER BY `unit` DESC [ RunTime:0.086998s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35279249 LIMIT 2 [ RunTime:0.069146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35279249 ORDER BY `minOrder` ASC [ RunTime:0.009340s ]
select * from pdf where partno='2105-7521-005' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.013027s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105-7521-005' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.036650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35278440 LIMIT 4 [ RunTime:0.076825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35278440 ORDER BY `minOrder` ASC [ RunTime:0.047409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35278440 ORDER BY `unit` DESC [ RunTime:0.091403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35278440 LIMIT 2 [ RunTime:0.039171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35278440 ORDER BY `minOrder` ASC [ RunTime:0.117909s ]
select * from pdf where partno='2105-7521-002' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.108983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105-7521-002' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.078400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35278099 LIMIT 4 [ RunTime:0.041258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35278099 ORDER BY `minOrder` ASC [ RunTime:0.073922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35278099 ORDER BY `unit` DESC [ RunTime:0.039110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35278099 LIMIT 2 [ RunTime:0.068874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35278099 ORDER BY `minOrder` ASC [ RunTime:0.003596s ]
select * from pdf where partno='2109-1511-011' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.015578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109-1511-011' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.019757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35273458 LIMIT 4 [ RunTime:0.046256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35273458 ORDER BY `minOrder` ASC [ RunTime:0.041611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35273458 ORDER BY `unit` DESC [ RunTime:0.088210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35273458 LIMIT 2 [ RunTime:0.112155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35273458 ORDER BY `minOrder` ASC [ RunTime:0.045755s ]
select * from pdf where partno='2105-1521-019' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.029077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105-1521-019' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.100177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35272369 LIMIT 4 [ RunTime:0.050654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35272369 ORDER BY `minOrder` ASC [ RunTime:0.082948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35272369 ORDER BY `unit` DESC [ RunTime:0.160182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35272369 LIMIT 2 [ RunTime:0.110598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35272369 ORDER BY `minOrder` ASC [ RunTime:0.040051s ]
select * from pdf where partno='2105-7521-003' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.113428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105-7521-003' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.051843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35272042 LIMIT 4 [ RunTime:0.099372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35272042 ORDER BY `minOrder` ASC [ RunTime:0.106182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35272042 ORDER BY `unit` DESC [ RunTime:0.031634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35272042 LIMIT 2 [ RunTime:0.147904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35272042 ORDER BY `minOrder` ASC [ RunTime:0.070113s ]
select * from pdf where partno='2105-1521-003' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.080198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105-1521-003' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.094061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35268440 LIMIT 4 [ RunTime:0.063900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35268440 ORDER BY `minOrder` ASC [ RunTime:0.109266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35268440 ORDER BY `unit` DESC [ RunTime:0.155156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35268440 LIMIT 2 [ RunTime:0.060753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35268440 ORDER BY `minOrder` ASC [ RunTime:0.034595s ]
select * from pdf where partno='2101520-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.033719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101520-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.075569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35207255 LIMIT 4 [ RunTime:0.149612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35207255 ORDER BY `minOrder` ASC [ RunTime:0.058615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35207255 ORDER BY `unit` DESC [ RunTime:0.056764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35207255 LIMIT 2 [ RunTime:0.085480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35207255 ORDER BY `minOrder` ASC [ RunTime:0.003028s ]
select * from pdf where partno='2102343-3' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.044290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102343-3' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.053283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34887822 LIMIT 4 [ RunTime:0.078766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34887822 ORDER BY `minOrder` ASC [ RunTime:0.029330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34887822 ORDER BY `unit` DESC [ RunTime:0.060156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34887822 LIMIT 2 [ RunTime:0.010573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34887822 ORDER BY `minOrder` ASC [ RunTime:0.009338s ]
select * from pdf where partno='2101677-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.038126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101677-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.077670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34759722 LIMIT 4 [ RunTime:0.106915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34759722 ORDER BY `minOrder` ASC [ RunTime:0.055255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34759722 ORDER BY `unit` DESC [ RunTime:0.025403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34759722 LIMIT 2 [ RunTime:0.045144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34759722 ORDER BY `minOrder` ASC [ RunTime:0.023878s ]
select * from pdf where partno='2102353-7' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.086937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102353-7' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.118014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34757008 LIMIT 4 [ RunTime:0.035521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34757008 ORDER BY `minOrder` ASC [ RunTime:0.029268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34757008 ORDER BY `unit` DESC [ RunTime:0.017030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34757008 LIMIT 2 [ RunTime:0.023670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34757008 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
select * from pdf where partno='2101550-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.034738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101550-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.040059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34706020 LIMIT 4 [ RunTime:0.159826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34706020 ORDER BY `minOrder` ASC [ RunTime:0.063636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34706020 ORDER BY `unit` DESC [ RunTime:0.044339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34706020 LIMIT 2 [ RunTime:0.044627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34706020 ORDER BY `minOrder` ASC [ RunTime:0.018957s ]
select * from pdf where partno='2102659-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.033561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102659-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.068524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34644264 LIMIT 4 [ RunTime:0.036821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34644264 ORDER BY `minOrder` ASC [ RunTime:0.042036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34644264 ORDER BY `unit` DESC [ RunTime:0.039163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34644264 LIMIT 2 [ RunTime:0.036701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34644264 ORDER BY `minOrder` ASC [ RunTime:0.020604s ]
select * from pdf where partno='21033836465' and brandshort='HARTING' limit 1 [ RunTime:0.031526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033836465' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.034278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34625360 LIMIT 4 [ RunTime:0.023511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34625360 ORDER BY `minOrder` ASC [ RunTime:0.011941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34625360 ORDER BY `unit` DESC [ RunTime:0.054208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34625360 LIMIT 2 [ RunTime:0.087141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34625360 ORDER BY `minOrder` ASC [ RunTime:0.010442s ]
select * from pdf where partno='21033836451' and brandshort='HARTING' limit 1 [ RunTime:0.014252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033836451' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.052621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34594407 LIMIT 4 [ RunTime:0.034016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34594407 ORDER BY `minOrder` ASC [ RunTime:0.058327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34594407 ORDER BY `unit` DESC [ RunTime:0.082403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34594407 LIMIT 2 [ RunTime:0.095527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34594407 ORDER BY `minOrder` ASC [ RunTime:0.008315s ]
select * from pdf where partno='21033836461' and brandshort='HARTING' limit 1 [ RunTime:0.032083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033836461' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.060166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34565897 LIMIT 4 [ RunTime:0.069221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34565897 ORDER BY `minOrder` ASC [ RunTime:0.051026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34565897 ORDER BY `unit` DESC [ RunTime:0.028057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34565897 LIMIT 2 [ RunTime:0.087634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34565897 ORDER BY `minOrder` ASC [ RunTime:0.051137s ]
select * from pdf where partno='21033814860' and brandshort='HARTING' limit 1 [ RunTime:0.049338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814860' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.089752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34564854 LIMIT 4 [ RunTime:0.090244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34564854 ORDER BY `minOrder` ASC [ RunTime:0.067073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34564854 ORDER BY `unit` DESC [ RunTime:0.112763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34564854 LIMIT 2 [ RunTime:0.035855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34564854 ORDER BY `minOrder` ASC [ RunTime:0.137614s ]
select * from pdf where partno='21033412425' and brandshort='HARTING' limit 1 [ RunTime:0.055322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033412425' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.097233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34556855 LIMIT 4 [ RunTime:0.061624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34556855 ORDER BY `minOrder` ASC [ RunTime:0.060145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34556855 ORDER BY `unit` DESC [ RunTime:0.051927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34556855 LIMIT 2 [ RunTime:0.085499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34556855 ORDER BY `minOrder` ASC [ RunTime:0.009080s ]
select * from pdf where partno='21033411425' and brandshort='HARTING' limit 1 [ RunTime:0.015033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033411425' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.043738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34552885 LIMIT 4 [ RunTime:0.016239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34552885 ORDER BY `minOrder` ASC [ RunTime:0.059772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34552885 ORDER BY `unit` DESC [ RunTime:0.026784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34552885 LIMIT 2 [ RunTime:0.038449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34552885 ORDER BY `minOrder` ASC [ RunTime:0.028938s ]
select * from pdf where partno='21033822401' and brandshort='HARTING' limit 1 [ RunTime:0.020512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033822401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.074163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34545451 LIMIT 4 [ RunTime:0.022473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34545451 ORDER BY `minOrder` ASC [ RunTime:0.068648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34545451 ORDER BY `unit` DESC [ RunTime:0.050329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34545451 LIMIT 2 [ RunTime:0.061861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34545451 ORDER BY `minOrder` ASC [ RunTime:0.017691s ]
select * from pdf where partno='21033222401' and brandshort='HARTING' limit 1 [ RunTime:0.001806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033222401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.006693s ]
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.010730s ]