SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001867s ]
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.010647s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002042s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001997s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003301s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.001628s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002079s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008116s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001942s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.038906s ]
UPDATE `stock_search` SET `count` = 2252 , `updatetime` = '2026-06-07 00:04:28' WHERE `partno` = '210' [ RunTime:0.015041s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006995s ]
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.008003s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001431s ]
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.015795s ]
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 2380,20 [ RunTime:0.086225s ]
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 ('34323011','34323003','34322935','34322801','34322776','34322684','34322614','34322452','34321881','34306145','34303333','34302360','34302135','34301890','34301045','34300607','34300464','34300463','34300174','34300134') ORDER BY FIELD(s.id, 34323011,34323003,34322935,34322801,34322776,34322684,34322614,34322452,34321881,34306145,34303333,34302360,34302135,34301890,34301045,34300607,34300464,34300463,34300174,34300134) [ RunTime:0.061894s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323011 LIMIT 4 [ RunTime:0.056985s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323011 ORDER BY `minOrder` ASC [ RunTime:0.047498s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323011 ORDER BY `unit` DESC [ RunTime:0.030244s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323011 LIMIT 2 [ RunTime:0.042835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323011 ORDER BY `minOrder` ASC [ RunTime:0.014766s ]
select * from pdf where partno='210-1-24-006' and brandshort='CNC Tech' limit 1 [ RunTime:0.023060s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-1-24-006' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.011348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34323003 LIMIT 4 [ RunTime:0.042235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323003 ORDER BY `minOrder` ASC [ RunTime:0.046396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34323003 ORDER BY `unit` DESC [ RunTime:0.086182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34323003 LIMIT 2 [ RunTime:0.026395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34323003 ORDER BY `minOrder` ASC [ RunTime:0.031277s ]
select * from pdf where partno='210-83-308-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.077082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-308-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.039869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322935 LIMIT 4 [ RunTime:0.077506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322935 ORDER BY `minOrder` ASC [ RunTime:0.041689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322935 ORDER BY `unit` DESC [ RunTime:0.074431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322935 LIMIT 2 [ RunTime:0.057988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322935 ORDER BY `minOrder` ASC [ RunTime:0.050988s ]
select * from pdf where partno='210-87-314-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.036841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-314-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.064501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322801 LIMIT 4 [ RunTime:0.024817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322801 ORDER BY `minOrder` ASC [ RunTime:0.049304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322801 ORDER BY `unit` DESC [ RunTime:0.077148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322801 LIMIT 2 [ RunTime:0.029144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322801 ORDER BY `minOrder` ASC [ RunTime:0.026464s ]
select * from pdf where partno='210-83-306-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.035528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-83-306-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.064846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322776 LIMIT 4 [ RunTime:0.082757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322776 ORDER BY `minOrder` ASC [ RunTime:0.096147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322776 ORDER BY `unit` DESC [ RunTime:0.049253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322776 LIMIT 2 [ RunTime:0.038144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322776 ORDER BY `minOrder` ASC [ RunTime:0.042680s ]
select * from pdf where partno='210-87-310-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.031922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-310-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.019209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322684 LIMIT 4 [ RunTime:0.070226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322684 ORDER BY `minOrder` ASC [ RunTime:0.059221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322684 ORDER BY `unit` DESC [ RunTime:0.047293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322684 LIMIT 2 [ RunTime:0.036972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322684 ORDER BY `minOrder` ASC [ RunTime:0.075491s ]
select * from pdf where partno='210-87-308-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.109632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-308-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.051295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322614 LIMIT 4 [ RunTime:0.069339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322614 ORDER BY `minOrder` ASC [ RunTime:0.059451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322614 ORDER BY `unit` DESC [ RunTime:0.029813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322614 LIMIT 2 [ RunTime:0.076608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322614 ORDER BY `minOrder` ASC [ RunTime:0.027307s ]
select * from pdf where partno='210-87-306-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.042116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-87-306-41-001101' OR `brand` LIKE 'Preci-Dip%' ) ) LIMIT 1 [ RunTime:0.033930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322452 LIMIT 4 [ RunTime:0.105442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322452 ORDER BY `minOrder` ASC [ RunTime:0.039617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322452 ORDER BY `unit` DESC [ RunTime:0.080949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322452 LIMIT 2 [ RunTime:0.014017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322452 ORDER BY `minOrder` ASC [ RunTime:0.036820s ]
select * from pdf where partno='210-1-40-006' and brandshort='CNC Tech' limit 1 [ RunTime:0.029666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-1-40-006' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.101402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34321881 LIMIT 4 [ RunTime:0.043615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34321881 ORDER BY `minOrder` ASC [ RunTime:0.089534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34321881 ORDER BY `unit` DESC [ RunTime:0.065713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34321881 LIMIT 2 [ RunTime:0.052217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34321881 ORDER BY `minOrder` ASC [ RunTime:0.061588s ]
select * from pdf where partno='210815-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.033490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210815-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.049670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34306145 LIMIT 4 [ RunTime:0.026161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34306145 ORDER BY `minOrder` ASC [ RunTime:0.081126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34306145 ORDER BY `unit` DESC [ RunTime:0.153390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34306145 LIMIT 2 [ RunTime:0.019246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34306145 ORDER BY `minOrder` ASC [ RunTime:0.009329s ]
select * from pdf where partno='2101882-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.034221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101882-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.064134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34303333 LIMIT 4 [ RunTime:0.064645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34303333 ORDER BY `minOrder` ASC [ RunTime:0.027716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34303333 ORDER BY `unit` DESC [ RunTime:0.031606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34303333 LIMIT 2 [ RunTime:0.056962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34303333 ORDER BY `minOrder` ASC [ RunTime:0.064708s ]
select * from pdf where partno='2108102-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.049944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108102-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.111203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34302360 LIMIT 4 [ RunTime:0.225175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34302360 ORDER BY `minOrder` ASC [ RunTime:0.157808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34302360 ORDER BY `unit` DESC [ RunTime:0.069169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34302360 LIMIT 2 [ RunTime:0.053268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34302360 ORDER BY `minOrder` ASC [ RunTime:0.096999s ]
select * from pdf where partno='2102232-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.044508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102232-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.069983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34302135 LIMIT 4 [ RunTime:0.066321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34302135 ORDER BY `minOrder` ASC [ RunTime:0.016067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34302135 ORDER BY `unit` DESC [ RunTime:0.064859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34302135 LIMIT 2 [ RunTime:0.128581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34302135 ORDER BY `minOrder` ASC [ RunTime:0.017039s ]
select * from pdf where partno='2102320-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.084172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102320-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.045846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34301890 LIMIT 4 [ RunTime:0.058166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34301890 ORDER BY `minOrder` ASC [ RunTime:0.043522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34301890 ORDER BY `unit` DESC [ RunTime:0.013600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34301890 LIMIT 2 [ RunTime:0.105476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34301890 ORDER BY `minOrder` ASC [ RunTime:0.063431s ]
select * from pdf where partno='2102096-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.066047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102096-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.010541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34301045 LIMIT 4 [ RunTime:0.066525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34301045 ORDER BY `minOrder` ASC [ RunTime:0.069342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34301045 ORDER BY `unit` DESC [ RunTime:0.121342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34301045 LIMIT 2 [ RunTime:0.083248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34301045 ORDER BY `minOrder` ASC [ RunTime:0.025298s ]
select * from pdf where partno='2102319-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.010384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102319-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.037279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34300607 LIMIT 4 [ RunTime:0.024988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300607 ORDER BY `minOrder` ASC [ RunTime:0.018036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34300607 ORDER BY `unit` DESC [ RunTime:0.033757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34300607 LIMIT 2 [ RunTime:0.036772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300607 ORDER BY `minOrder` ASC [ RunTime:0.006234s ]
select * from pdf where partno='2102849-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.003212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102849-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.030290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34300464 LIMIT 4 [ RunTime:0.017295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300464 ORDER BY `minOrder` ASC [ RunTime:0.014373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34300464 ORDER BY `unit` DESC [ RunTime:0.020910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34300464 LIMIT 2 [ RunTime:0.008392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300464 ORDER BY `minOrder` ASC [ RunTime:0.001892s ]
select * from pdf where partno='2102436-3' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.042455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102436-3' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34300463 LIMIT 4 [ RunTime:0.020112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300463 ORDER BY `minOrder` ASC [ RunTime:0.012056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34300463 ORDER BY `unit` DESC [ RunTime:0.037225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34300463 LIMIT 2 [ RunTime:0.014598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300463 ORDER BY `minOrder` ASC [ RunTime:0.002017s ]
select * from pdf where partno='2102436-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.004255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102436-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.001604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34300174 LIMIT 4 [ RunTime:0.012603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300174 ORDER BY `minOrder` ASC [ RunTime:0.029288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34300174 ORDER BY `unit` DESC [ RunTime:0.041120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34300174 LIMIT 2 [ RunTime:0.041087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300174 ORDER BY `minOrder` ASC [ RunTime:0.034086s ]
select * from pdf where partno='2102183-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.004551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102183-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.061937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34300134 LIMIT 4 [ RunTime:0.101428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300134 ORDER BY `minOrder` ASC [ RunTime:0.028356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34300134 ORDER BY `unit` DESC [ RunTime:0.092507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34300134 LIMIT 2 [ RunTime:0.031903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300134 ORDER BY `minOrder` ASC [ RunTime:0.025041s ]
select * from pdf where partno='2102847-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.026104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102847-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.033977s ]
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.028166s ]