SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001301s ]
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.003251s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001104s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000669s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002965s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.003375s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003401s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004693s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002323s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003636s ]
UPDATE `stock_search` SET `count` = 1960 , `updatetime` = '2026-06-06 21:05:28' WHERE `partno` = '210' [ RunTime:0.009080s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002028s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004517s ]
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.000619s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002492s ]
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.005816s ]
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 2780,20 [ RunTime:0.073419s ]
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 ('33469039','33469038','33469037','33468119','33467533','33466672','33465168','33454970','33453697','33445950','33443108','33442869','33442809','33442800','33442759','33442725','33433357','33432202','33422773','33420284') ORDER BY FIELD(s.id, 33469039,33469038,33469037,33468119,33467533,33466672,33465168,33454970,33453697,33445950,33443108,33442869,33442809,33442800,33442759,33442725,33433357,33432202,33422773,33420284) [ RunTime:0.016750s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33469039 LIMIT 4 [ RunTime:0.001938s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33469039 ORDER BY `minOrder` ASC [ RunTime:0.008152s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33469039 ORDER BY `unit` DESC [ RunTime:0.009355s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33469039 LIMIT 2 [ RunTime:0.003574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33469039 ORDER BY `minOrder` ASC [ RunTime:0.016029s ]
select * from pdf where partno='2103736-3' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.002143s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103736-3' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.017590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33469038 LIMIT 4 [ RunTime:0.022184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33469038 ORDER BY `minOrder` ASC [ RunTime:0.030934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33469038 ORDER BY `unit` DESC [ RunTime:0.010431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33469038 LIMIT 2 [ RunTime:0.002348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33469038 ORDER BY `minOrder` ASC [ RunTime:0.007105s ]
select * from pdf where partno='2103736-2' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.023306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103736-2' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.023596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33469037 LIMIT 4 [ RunTime:0.009209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33469037 ORDER BY `minOrder` ASC [ RunTime:0.017402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33469037 ORDER BY `unit` DESC [ RunTime:0.020915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33469037 LIMIT 2 [ RunTime:0.005764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33469037 ORDER BY `minOrder` ASC [ RunTime:0.004044s ]
select * from pdf where partno='2103736-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.016704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103736-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.018072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33468119 LIMIT 4 [ RunTime:0.021818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33468119 ORDER BY `minOrder` ASC [ RunTime:0.070252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33468119 ORDER BY `unit` DESC [ RunTime:0.013233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33468119 LIMIT 2 [ RunTime:0.007223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33468119 ORDER BY `minOrder` ASC [ RunTime:0.008935s ]
select * from pdf where partno='2106749-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106749-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33467533 LIMIT 4 [ RunTime:0.035836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33467533 ORDER BY `minOrder` ASC [ RunTime:0.040167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33467533 ORDER BY `unit` DESC [ RunTime:0.022767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33467533 LIMIT 2 [ RunTime:0.008851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33467533 ORDER BY `minOrder` ASC [ RunTime:0.008034s ]
select * from pdf where partno='2108743-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108743-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.037285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33466672 LIMIT 4 [ RunTime:0.021538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33466672 ORDER BY `minOrder` ASC [ RunTime:0.052799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33466672 ORDER BY `unit` DESC [ RunTime:0.008935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33466672 LIMIT 2 [ RunTime:0.019198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33466672 ORDER BY `minOrder` ASC [ RunTime:0.010005s ]
select * from pdf where partno='2103157-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103157-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33465168 LIMIT 4 [ RunTime:0.004321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33465168 ORDER BY `minOrder` ASC [ RunTime:0.013827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33465168 ORDER BY `unit` DESC [ RunTime:0.017920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33465168 LIMIT 2 [ RunTime:0.006901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33465168 ORDER BY `minOrder` ASC [ RunTime:0.026158s ]
select * from pdf where partno='2108963-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108963-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.025890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33454970 LIMIT 4 [ RunTime:0.010237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33454970 ORDER BY `minOrder` ASC [ RunTime:0.045094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33454970 ORDER BY `unit` DESC [ RunTime:0.008214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33454970 LIMIT 2 [ RunTime:0.009301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33454970 ORDER BY `minOrder` ASC [ RunTime:0.007509s ]
select * from pdf where partno='21011009927' and brandshort='HARTING' limit 1 [ RunTime:0.012956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009927' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.029433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33453697 LIMIT 4 [ RunTime:0.015730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33453697 ORDER BY `minOrder` ASC [ RunTime:0.011243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33453697 ORDER BY `unit` DESC [ RunTime:0.014180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33453697 LIMIT 2 [ RunTime:0.018249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33453697 ORDER BY `minOrder` ASC [ RunTime:0.008177s ]
select * from pdf where partno='21011009023' and brandshort='HARTING' limit 1 [ RunTime:0.014905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009023' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.019370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33445950 LIMIT 4 [ RunTime:0.014181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33445950 ORDER BY `minOrder` ASC [ RunTime:0.018487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33445950 ORDER BY `unit` DESC [ RunTime:0.028327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33445950 LIMIT 2 [ RunTime:0.020574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33445950 ORDER BY `minOrder` ASC [ RunTime:0.018257s ]
select * from pdf where partno='2100-0379' and brandshort='Metcal' limit 1 [ RunTime:0.011501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-0379' OR `brand` LIKE 'Metcal%' ) ) LIMIT 1 [ RunTime:0.021557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33443108 LIMIT 4 [ RunTime:0.032661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33443108 ORDER BY `minOrder` ASC [ RunTime:0.028307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33443108 ORDER BY `unit` DESC [ RunTime:0.006535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33443108 LIMIT 2 [ RunTime:0.006112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33443108 ORDER BY `minOrder` ASC [ RunTime:0.005679s ]
select * from pdf where partno='2109006-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.030216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109006-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.044496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33442869 LIMIT 4 [ RunTime:0.067203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442869 ORDER BY `minOrder` ASC [ RunTime:0.028061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33442869 ORDER BY `unit` DESC [ RunTime:0.053886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33442869 LIMIT 2 [ RunTime:0.022206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442869 ORDER BY `minOrder` ASC [ RunTime:0.024182s ]
select * from pdf where partno='2109006-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.035112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109006-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.029173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33442809 LIMIT 4 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442809 ORDER BY `minOrder` ASC [ RunTime:0.045808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33442809 ORDER BY `unit` DESC [ RunTime:0.023646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33442809 LIMIT 2 [ RunTime:0.009044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442809 ORDER BY `minOrder` ASC [ RunTime:0.002353s ]
select * from pdf where partno='2109006-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109006-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.026549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33442800 LIMIT 4 [ RunTime:0.014348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442800 ORDER BY `minOrder` ASC [ RunTime:0.013671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33442800 ORDER BY `unit` DESC [ RunTime:0.011481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33442800 LIMIT 2 [ RunTime:0.039350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442800 ORDER BY `minOrder` ASC [ RunTime:0.003881s ]
select * from pdf where partno='2109005-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109005-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33442759 LIMIT 4 [ RunTime:0.008808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442759 ORDER BY `minOrder` ASC [ RunTime:0.016557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33442759 ORDER BY `unit` DESC [ RunTime:0.023563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33442759 LIMIT 2 [ RunTime:0.006119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442759 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
select * from pdf where partno='2109005-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.029730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109005-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.025875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33442725 LIMIT 4 [ RunTime:0.014180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442725 ORDER BY `minOrder` ASC [ RunTime:0.014058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33442725 ORDER BY `unit` DESC [ RunTime:0.021624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33442725 LIMIT 2 [ RunTime:0.013767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33442725 ORDER BY `minOrder` ASC [ RunTime:0.023227s ]
select * from pdf where partno='2109005-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.027011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109005-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33433357 LIMIT 4 [ RunTime:0.019405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33433357 ORDER BY `minOrder` ASC [ RunTime:0.031965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33433357 ORDER BY `unit` DESC [ RunTime:0.010375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33433357 LIMIT 2 [ RunTime:0.013227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33433357 ORDER BY `minOrder` ASC [ RunTime:0.004929s ]
select * from pdf where partno='21011009963' and brandshort='HARTING' limit 1 [ RunTime:0.008235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009963' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.017012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33432202 LIMIT 4 [ RunTime:0.007162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33432202 ORDER BY `minOrder` ASC [ RunTime:0.062432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33432202 ORDER BY `unit` DESC [ RunTime:0.017919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33432202 LIMIT 2 [ RunTime:0.003936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33432202 ORDER BY `minOrder` ASC [ RunTime:0.020239s ]
select * from pdf where partno='21011009964' and brandshort='HARTING' limit 1 [ RunTime:0.008732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009964' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33422773 LIMIT 4 [ RunTime:0.009759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33422773 ORDER BY `minOrder` ASC [ RunTime:0.014408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33422773 ORDER BY `unit` DESC [ RunTime:0.030283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33422773 LIMIT 2 [ RunTime:0.023882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33422773 ORDER BY `minOrder` ASC [ RunTime:0.010427s ]
select * from pdf where partno='2101580-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.014330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101580-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33420284 LIMIT 4 [ RunTime:0.042839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33420284 ORDER BY `minOrder` ASC [ RunTime:0.059039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33420284 ORDER BY `unit` DESC [ RunTime:0.017569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33420284 LIMIT 2 [ RunTime:0.006132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33420284 ORDER BY `minOrder` ASC [ RunTime:0.010592s ]
select * from pdf where partno='21010100024' and brandshort='HARTING' limit 1 [ RunTime:0.012178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21010100024' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.018805s ]
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.008202s ]