SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002619s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.174' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.247555s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002903s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.061128s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001900s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.035106s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001835s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.017594s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001978s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.104405s ]
UPDATE `stock_search` SET `count` = 2361 , `updatetime` = '2026-06-07 01:13:05' WHERE `partno` = '210' [ RunTime:0.058040s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.038463s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.020888s ]
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.025211s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003350s ]
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.094780s ]
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 2400,20 [ RunTime:0.080783s ]
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 ('34300111','34300009','34300008','34299545','34299393','34299385','34299331','34299330','34299298','34298831','34298596','34298346','34298342','34297966','34297228','34297227','34295654','34294370','34294223','34294141') ORDER BY FIELD(s.id, 34300111,34300009,34300008,34299545,34299393,34299385,34299331,34299330,34299298,34298831,34298596,34298346,34298342,34297966,34297228,34297227,34295654,34294370,34294223,34294141) [ RunTime:0.015731s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34300111 LIMIT 4 [ RunTime:0.014515s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300111 ORDER BY `minOrder` ASC [ RunTime:0.013551s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34300111 ORDER BY `unit` DESC [ RunTime:0.044847s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.030410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34300111 LIMIT 2 [ RunTime:0.022494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300111 ORDER BY `minOrder` ASC [ RunTime:0.018614s ]
select * from pdf where partno='2102081-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.055595s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102081-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.072872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34300009 LIMIT 4 [ RunTime:0.067093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300009 ORDER BY `minOrder` ASC [ RunTime:0.018396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34300009 ORDER BY `unit` DESC [ RunTime:0.025867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34300009 LIMIT 2 [ RunTime:0.028362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300009 ORDER BY `minOrder` ASC [ RunTime:0.021332s ]
select * from pdf where partno='2102436-4' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.081253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102436-4' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.060070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34300008 LIMIT 4 [ RunTime:0.036225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300008 ORDER BY `minOrder` ASC [ RunTime:0.036729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34300008 ORDER BY `unit` DESC [ RunTime:0.035047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34300008 LIMIT 2 [ RunTime:0.036721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34300008 ORDER BY `minOrder` ASC [ RunTime:0.022019s ]
select * from pdf where partno='2102773-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.058007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102773-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.015135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34299545 LIMIT 4 [ RunTime:0.022834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299545 ORDER BY `minOrder` ASC [ RunTime:0.091458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34299545 ORDER BY `unit` DESC [ RunTime:0.034967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34299545 LIMIT 2 [ RunTime:0.012297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299545 ORDER BY `minOrder` ASC [ RunTime:0.001051s ]
select * from pdf where partno='2102161-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.015373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102161-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.014647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34299393 LIMIT 4 [ RunTime:0.009598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299393 ORDER BY `minOrder` ASC [ RunTime:0.005048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34299393 ORDER BY `unit` DESC [ RunTime:0.013983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34299393 LIMIT 2 [ RunTime:0.007137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299393 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
select * from pdf where partno='2102087-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102087-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.013839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34299385 LIMIT 4 [ RunTime:0.043375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299385 ORDER BY `minOrder` ASC [ RunTime:0.016638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34299385 ORDER BY `unit` DESC [ RunTime:0.172614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34299385 LIMIT 2 [ RunTime:0.008285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299385 ORDER BY `minOrder` ASC [ RunTime:0.009706s ]
select * from pdf where partno='2102086-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.013878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102086-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.010753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34299331 LIMIT 4 [ RunTime:0.009310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299331 ORDER BY `minOrder` ASC [ RunTime:0.028212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34299331 ORDER BY `unit` DESC [ RunTime:0.075311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34299331 LIMIT 2 [ RunTime:0.029569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299331 ORDER BY `minOrder` ASC [ RunTime:0.053329s ]
select * from pdf where partno='2102088-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.068930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102088-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.061921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34299330 LIMIT 4 [ RunTime:0.036098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299330 ORDER BY `minOrder` ASC [ RunTime:0.092924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34299330 ORDER BY `unit` DESC [ RunTime:0.076689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34299330 LIMIT 2 [ RunTime:0.038817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299330 ORDER BY `minOrder` ASC [ RunTime:0.033633s ]
select * from pdf where partno='2102087-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.042348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102087-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.065643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34299298 LIMIT 4 [ RunTime:0.051112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299298 ORDER BY `minOrder` ASC [ RunTime:0.006781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34299298 ORDER BY `unit` DESC [ RunTime:0.071645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34299298 LIMIT 2 [ RunTime:0.075990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34299298 ORDER BY `minOrder` ASC [ RunTime:0.054022s ]
select * from pdf where partno='2102081-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.051264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102081-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.076822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34298831 LIMIT 4 [ RunTime:0.046046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34298831 ORDER BY `minOrder` ASC [ RunTime:0.030658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34298831 ORDER BY `unit` DESC [ RunTime:0.029062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34298831 LIMIT 2 [ RunTime:0.013795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34298831 ORDER BY `minOrder` ASC [ RunTime:0.013226s ]
select * from pdf where partno='2102315-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.066936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102315-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.020303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34298596 LIMIT 4 [ RunTime:0.042159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34298596 ORDER BY `minOrder` ASC [ RunTime:0.025125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34298596 ORDER BY `unit` DESC [ RunTime:0.042773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34298596 LIMIT 2 [ RunTime:0.129427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34298596 ORDER BY `minOrder` ASC [ RunTime:0.082677s ]
select * from pdf where partno='2102234-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.050437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102234-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.048362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34298346 LIMIT 4 [ RunTime:0.028642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34298346 ORDER BY `minOrder` ASC [ RunTime:0.032006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34298346 ORDER BY `unit` DESC [ RunTime:0.037470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34298346 LIMIT 2 [ RunTime:0.106575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34298346 ORDER BY `minOrder` ASC [ RunTime:0.032158s ]
select * from pdf where partno='2102155-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.041427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102155-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.032888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34298342 LIMIT 4 [ RunTime:0.080895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34298342 ORDER BY `minOrder` ASC [ RunTime:0.005625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34298342 ORDER BY `unit` DESC [ RunTime:0.052069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34298342 LIMIT 2 [ RunTime:0.098077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34298342 ORDER BY `minOrder` ASC [ RunTime:0.009872s ]
select * from pdf where partno='2102086-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.079344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102086-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.048655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34297966 LIMIT 4 [ RunTime:0.053174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34297966 ORDER BY `minOrder` ASC [ RunTime:0.062610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34297966 ORDER BY `unit` DESC [ RunTime:0.051083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34297966 LIMIT 2 [ RunTime:0.016786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34297966 ORDER BY `minOrder` ASC [ RunTime:0.036399s ]
select * from pdf where partno='2102098-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.040559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102098-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.022195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34297228 LIMIT 4 [ RunTime:0.038457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34297228 ORDER BY `minOrder` ASC [ RunTime:0.028615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34297228 ORDER BY `unit` DESC [ RunTime:0.037699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34297228 LIMIT 2 [ RunTime:0.027190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34297228 ORDER BY `minOrder` ASC [ RunTime:0.015497s ]
select * from pdf where partno='2102775-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102775-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.040549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34297227 LIMIT 4 [ RunTime:0.017759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34297227 ORDER BY `minOrder` ASC [ RunTime:0.007341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34297227 ORDER BY `unit` DESC [ RunTime:0.012390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34297227 LIMIT 2 [ RunTime:0.023004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34297227 ORDER BY `minOrder` ASC [ RunTime:0.026381s ]
select * from pdf where partno='2102848-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.005950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102848-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.006184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34295654 LIMIT 4 [ RunTime:0.028109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34295654 ORDER BY `minOrder` ASC [ RunTime:0.014965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34295654 ORDER BY `unit` DESC [ RunTime:0.021763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34295654 LIMIT 2 [ RunTime:0.004160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34295654 ORDER BY `minOrder` ASC [ RunTime:0.007809s ]
select * from pdf where partno='2102438-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.014288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102438-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.014385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34294370 LIMIT 4 [ RunTime:0.038121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34294370 ORDER BY `minOrder` ASC [ RunTime:0.056409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34294370 ORDER BY `unit` DESC [ RunTime:0.063196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34294370 LIMIT 2 [ RunTime:0.129900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34294370 ORDER BY `minOrder` ASC [ RunTime:0.067182s ]
select * from pdf where partno='2102094-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.087806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102094-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.077779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34294223 LIMIT 4 [ RunTime:0.101441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34294223 ORDER BY `minOrder` ASC [ RunTime:0.071971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34294223 ORDER BY `unit` DESC [ RunTime:0.054889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34294223 LIMIT 2 [ RunTime:0.057801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34294223 ORDER BY `minOrder` ASC [ RunTime:0.018376s ]
select * from pdf where partno='2102314-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.122927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102314-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.141607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34294141 LIMIT 4 [ RunTime:0.106330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34294141 ORDER BY `minOrder` ASC [ RunTime:0.035820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34294141 ORDER BY `unit` DESC [ RunTime:0.064893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34294141 LIMIT 2 [ RunTime:0.033720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34294141 ORDER BY `minOrder` ASC [ RunTime:0.050855s ]
select * from pdf where partno='2102092-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.078794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102092-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.076600s ]
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.118728s ]