SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001857s ]
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.001462s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002464s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001317s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001440s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002672s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001187s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.006025s ]
UPDATE `stock_search` SET `count` = 3967 , `updatetime` = '2026-06-08 15:56:56' WHERE `partno` = '210' [ RunTime:0.006743s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000260s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000251s ]
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.000497s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002810s ]
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.000402s ]
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 4800,20 [ RunTime:0.056657s ]
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 ('33528906','33528875','33528857','33528821','33528820','33528819','33528818','33528817','33528816','33528808','33528807','33528806','33528805','33528779','33528778','33528765','33528764','33528763','33478970','33478568') ORDER BY FIELD(s.id, 33528906,33528875,33528857,33528821,33528820,33528819,33528818,33528817,33528816,33528808,33528807,33528806,33528805,33528779,33528778,33528765,33528764,33528763,33478970,33478568) [ RunTime:0.024551s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528906 LIMIT 4 [ RunTime:0.011438s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528906 ORDER BY `minOrder` ASC [ RunTime:0.020238s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528906 ORDER BY `unit` DESC [ RunTime:0.010481s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528906 LIMIT 2 [ RunTime:0.010692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528906 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
select * from pdf where partno='2100109' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100109' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528875 LIMIT 4 [ RunTime:0.001228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528875 ORDER BY `minOrder` ASC [ RunTime:0.005569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528875 ORDER BY `unit` DESC [ RunTime:0.037855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528875 LIMIT 2 [ RunTime:0.043984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528875 ORDER BY `minOrder` ASC [ RunTime:0.006193s ]
select * from pdf where partno='2100106' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100106' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.016761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528857 LIMIT 4 [ RunTime:0.031795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528857 ORDER BY `minOrder` ASC [ RunTime:0.024081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528857 ORDER BY `unit` DESC [ RunTime:0.050195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528857 LIMIT 2 [ RunTime:0.023288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528857 ORDER BY `minOrder` ASC [ RunTime:0.006417s ]
select * from pdf where partno='2100120' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.039777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100120' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.027926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528821 LIMIT 4 [ RunTime:0.042101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528821 ORDER BY `minOrder` ASC [ RunTime:0.040416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528821 ORDER BY `unit` DESC [ RunTime:0.024092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528821 LIMIT 2 [ RunTime:0.090063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528821 ORDER BY `minOrder` ASC [ RunTime:0.039202s ]
select * from pdf where partno='2100123' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.034604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100123' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.081691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528820 LIMIT 4 [ RunTime:0.074102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528820 ORDER BY `minOrder` ASC [ RunTime:0.085743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528820 ORDER BY `unit` DESC [ RunTime:0.042045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528820 LIMIT 2 [ RunTime:0.046434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528820 ORDER BY `minOrder` ASC [ RunTime:0.086189s ]
select * from pdf where partno='2100111' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.038120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100111' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.048189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528819 LIMIT 4 [ RunTime:0.074298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528819 ORDER BY `minOrder` ASC [ RunTime:0.033509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528819 ORDER BY `unit` DESC [ RunTime:0.102580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528819 LIMIT 2 [ RunTime:0.062516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528819 ORDER BY `minOrder` ASC [ RunTime:0.018833s ]
select * from pdf where partno='2100116' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.031038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100116' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.037491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528818 LIMIT 4 [ RunTime:0.048239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528818 ORDER BY `minOrder` ASC [ RunTime:0.133255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528818 ORDER BY `unit` DESC [ RunTime:0.113442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528818 LIMIT 2 [ RunTime:0.008528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528818 ORDER BY `minOrder` ASC [ RunTime:0.002212s ]
select * from pdf where partno='2100128' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.041078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100128' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.097077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528817 LIMIT 4 [ RunTime:0.051738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528817 ORDER BY `minOrder` ASC [ RunTime:0.050963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528817 ORDER BY `unit` DESC [ RunTime:0.059963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528817 LIMIT 2 [ RunTime:0.047804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528817 ORDER BY `minOrder` ASC [ RunTime:0.020813s ]
select * from pdf where partno='2100131' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100131' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.016707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528816 LIMIT 4 [ RunTime:0.013799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528816 ORDER BY `minOrder` ASC [ RunTime:0.036853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528816 ORDER BY `unit` DESC [ RunTime:0.009076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528816 LIMIT 2 [ RunTime:0.012029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528816 ORDER BY `minOrder` ASC [ RunTime:0.012080s ]
select * from pdf where partno='2100134' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100134' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528808 LIMIT 4 [ RunTime:0.011130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528808 ORDER BY `minOrder` ASC [ RunTime:0.012044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528808 ORDER BY `unit` DESC [ RunTime:0.008392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528808 LIMIT 2 [ RunTime:0.001842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528808 ORDER BY `minOrder` ASC [ RunTime:0.005948s ]
select * from pdf where partno='2100078' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100078' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.037326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528807 LIMIT 4 [ RunTime:0.050291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528807 ORDER BY `minOrder` ASC [ RunTime:0.009958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528807 ORDER BY `unit` DESC [ RunTime:0.016180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528807 LIMIT 2 [ RunTime:0.033289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528807 ORDER BY `minOrder` ASC [ RunTime:0.008005s ]
select * from pdf where partno='2100096' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100096' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528806 LIMIT 4 [ RunTime:0.003416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528806 ORDER BY `minOrder` ASC [ RunTime:0.009760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528806 ORDER BY `unit` DESC [ RunTime:0.000974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528806 LIMIT 2 [ RunTime:0.007747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528806 ORDER BY `minOrder` ASC [ RunTime:0.017206s ]
select * from pdf where partno='2100121' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.020924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100121' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528805 LIMIT 4 [ RunTime:0.018007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528805 ORDER BY `minOrder` ASC [ RunTime:0.017138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528805 ORDER BY `unit` DESC [ RunTime:0.034016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528805 LIMIT 2 [ RunTime:0.013775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528805 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='2100133' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100133' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528779 LIMIT 4 [ RunTime:0.009381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528779 ORDER BY `minOrder` ASC [ RunTime:0.003352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528779 ORDER BY `unit` DESC [ RunTime:0.013234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528779 LIMIT 2 [ RunTime:0.012063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528779 ORDER BY `minOrder` ASC [ RunTime:0.011786s ]
select * from pdf where partno='2100118' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100118' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.022835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528778 LIMIT 4 [ RunTime:0.028973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528778 ORDER BY `minOrder` ASC [ RunTime:0.027877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528778 ORDER BY `unit` DESC [ RunTime:0.027195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528778 LIMIT 2 [ RunTime:0.019586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528778 ORDER BY `minOrder` ASC [ RunTime:0.008657s ]
select * from pdf where partno='2100062' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100062' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528765 LIMIT 4 [ RunTime:0.043584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528765 ORDER BY `minOrder` ASC [ RunTime:0.009748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528765 ORDER BY `unit` DESC [ RunTime:0.032917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528765 LIMIT 2 [ RunTime:0.029033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528765 ORDER BY `minOrder` ASC [ RunTime:0.008814s ]
select * from pdf where partno='2100085' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100085' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.035920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528764 LIMIT 4 [ RunTime:0.025375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528764 ORDER BY `minOrder` ASC [ RunTime:0.026337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528764 ORDER BY `unit` DESC [ RunTime:0.010664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528764 LIMIT 2 [ RunTime:0.008375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528764 ORDER BY `minOrder` ASC [ RunTime:0.000925s ]
select * from pdf where partno='2100095' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100095' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.022507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528763 LIMIT 4 [ RunTime:0.015846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528763 ORDER BY `minOrder` ASC [ RunTime:0.002569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528763 ORDER BY `unit` DESC [ RunTime:0.017100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528763 LIMIT 2 [ RunTime:0.032516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528763 ORDER BY `minOrder` ASC [ RunTime:0.006961s ]
select * from pdf where partno='2100091' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.031695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100091' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33478970 LIMIT 4 [ RunTime:0.010359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33478970 ORDER BY `minOrder` ASC [ RunTime:0.020512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33478970 ORDER BY `unit` DESC [ RunTime:0.023324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33478970 LIMIT 2 [ RunTime:0.020547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33478970 ORDER BY `minOrder` ASC [ RunTime:0.005562s ]
select * from pdf where partno='2102503-4' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.012370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102503-4' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.002675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33478568 LIMIT 4 [ RunTime:0.007548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33478568 ORDER BY `minOrder` ASC [ RunTime:0.028142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33478568 ORDER BY `unit` DESC [ RunTime:0.016225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33478568 LIMIT 2 [ RunTime:0.028145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33478568 ORDER BY `minOrder` ASC [ RunTime:0.014348s ]
select * from pdf where partno='2102449-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.074947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102449-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.029208s ]
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.028322s ]