SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001775s ]
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.002426s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000918s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004472s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001377s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000963s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000845s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.002607s ]
UPDATE `stock_search` SET `count` = 2806 , `updatetime` = '2026-06-08 08:15:16' WHERE `partno` = '210' [ RunTime:0.003482s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000181s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000158s ]
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.000339s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001736s ]
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.000320s ]
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 180,20 [ RunTime:0.053570s ]
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 ('33463493','33612424','34321225','11419034','33346862','37615320','33462765','36766046','36485958','32267374','32270788','32277634','32163132','32446275','33406149','32277760','32163258','34357521','12519934','32277492') ORDER BY FIELD(s.id, 33463493,33612424,34321225,11419034,33346862,37615320,33462765,36766046,36485958,32267374,32270788,32277634,32163132,32446275,33406149,32277760,32163258,34357521,12519934,32277492) [ RunTime:0.004975s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33463493 LIMIT 4 [ RunTime:0.003639s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33463493 ORDER BY `minOrder` ASC [ RunTime:0.021566s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33463493 ORDER BY `unit` DESC [ RunTime:0.012584s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33463493 LIMIT 2 [ RunTime:0.020043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33463493 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='2103181-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.023651s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103181-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.023191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33612424 LIMIT 4 [ RunTime:0.024507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33612424 ORDER BY `minOrder` ASC [ RunTime:0.021963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33612424 ORDER BY `unit` DESC [ RunTime:0.025822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33612424 LIMIT 2 [ RunTime:0.012978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33612424 ORDER BY `minOrder` ASC [ RunTime:0.004009s ]
select * from pdf where partno='2102-5201' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.014613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-5201' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.026202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34321225 LIMIT 4 [ RunTime:0.037703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34321225 ORDER BY `minOrder` ASC [ RunTime:0.066483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34321225 ORDER BY `unit` DESC [ RunTime:0.020058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34321225 LIMIT 2 [ RunTime:0.020874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34321225 ORDER BY `minOrder` ASC [ RunTime:0.019656s ]
select * from pdf where partno='210-93-308-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.046331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-308-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.031623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419034 LIMIT 4 [ RunTime:0.041800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419034 ORDER BY `minOrder` ASC [ RunTime:0.018648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419034 ORDER BY `unit` DESC [ RunTime:0.024651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419034 LIMIT 2 [ RunTime:0.025724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419034 ORDER BY `minOrder` ASC [ RunTime:0.000984s ]
select * from pdf where partno='2102-2-00-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.045551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346862 LIMIT 4 [ RunTime:0.025048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346862 ORDER BY `minOrder` ASC [ RunTime:0.046111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346862 ORDER BY `unit` DESC [ RunTime:0.086168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346862 LIMIT 2 [ RunTime:0.034851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346862 ORDER BY `minOrder` ASC [ RunTime:0.027304s ]
select * from pdf where partno='2106003-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.115079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106003-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37615320 LIMIT 4 [ RunTime:0.031536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37615320 ORDER BY `minOrder` ASC [ RunTime:0.040860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37615320 ORDER BY `unit` DESC [ RunTime:0.031416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37615320 LIMIT 2 [ RunTime:0.021082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37615320 ORDER BY `minOrder` ASC [ RunTime:0.016286s ]
select * from pdf where partno='2108857-6' and brandshort='TE Connectivity' limit 1 [ RunTime:0.017201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108857-6' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.044846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33462765 LIMIT 4 [ RunTime:0.025112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462765 ORDER BY `minOrder` ASC [ RunTime:0.013186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33462765 ORDER BY `unit` DESC [ RunTime:0.036643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33462765 LIMIT 2 [ RunTime:0.028675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462765 ORDER BY `minOrder` ASC [ RunTime:0.025444s ]
select * from pdf where partno='2103153-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.025291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103153-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.047813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36766046 LIMIT 4 [ RunTime:0.058829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766046 ORDER BY `minOrder` ASC [ RunTime:0.022570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36766046 ORDER BY `unit` DESC [ RunTime:0.006937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36766046 LIMIT 2 [ RunTime:0.003585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766046 ORDER BY `minOrder` ASC [ RunTime:0.001490s ]
select * from pdf where partno='2100-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.035853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-440-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.033051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36485958 LIMIT 4 [ RunTime:0.062936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36485958 ORDER BY `minOrder` ASC [ RunTime:0.053524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36485958 ORDER BY `unit` DESC [ RunTime:0.060116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36485958 LIMIT 2 [ RunTime:0.060173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36485958 ORDER BY `minOrder` ASC [ RunTime:0.042143s ]
select * from pdf where partno='210261-000' and brandshort='TE Connectivity' limit 1 [ RunTime:0.038349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210261-000' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.109479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267374 LIMIT 4 [ RunTime:0.054437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267374 ORDER BY `minOrder` ASC [ RunTime:0.098319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267374 ORDER BY `unit` DESC [ RunTime:0.066705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267374 LIMIT 2 [ RunTime:0.032007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267374 ORDER BY `minOrder` ASC [ RunTime:0.016262s ]
select * from pdf where partno='2103306-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.067311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103306-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.079459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270788 LIMIT 4 [ RunTime:0.054006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270788 ORDER BY `minOrder` ASC [ RunTime:0.057954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270788 ORDER BY `unit` DESC [ RunTime:0.140159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270788 LIMIT 2 [ RunTime:0.090905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270788 ORDER BY `minOrder` ASC [ RunTime:0.076533s ]
select * from pdf where partno='2102771-1' and brandshort='te connectivity' limit 1 [ RunTime:0.106063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102771-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.104276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277634 LIMIT 4 [ RunTime:0.093078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277634 ORDER BY `minOrder` ASC [ RunTime:0.196198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277634 ORDER BY `unit` DESC [ RunTime:0.043418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277634 LIMIT 2 [ RunTime:0.128372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277634 ORDER BY `minOrder` ASC [ RunTime:0.063341s ]
select * from pdf where partno='2106135-4' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.097752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106135-4' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.033473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163132 LIMIT 4 [ RunTime:0.161382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163132 ORDER BY `minOrder` ASC [ RunTime:0.070124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163132 ORDER BY `unit` DESC [ RunTime:0.089731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163132 LIMIT 2 [ RunTime:0.082028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163132 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
select * from pdf where partno='2106135-4' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.032229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106135-4' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.051485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32446275 LIMIT 4 [ RunTime:0.064989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446275 ORDER BY `minOrder` ASC [ RunTime:0.031595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32446275 ORDER BY `unit` DESC [ RunTime:0.056189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32446275 LIMIT 2 [ RunTime:0.098006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446275 ORDER BY `minOrder` ASC [ RunTime:0.050390s ]
select * from pdf where partno='2103' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.049085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.112885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33406149 LIMIT 4 [ RunTime:0.074899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33406149 ORDER BY `minOrder` ASC [ RunTime:0.166762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33406149 ORDER BY `unit` DESC [ RunTime:0.076323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33406149 LIMIT 2 [ RunTime:0.101511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33406149 ORDER BY `minOrder` ASC [ RunTime:0.065591s ]
select * from pdf where partno='2102-2-00-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.036377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-2-00-01-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.107335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277760 LIMIT 4 [ RunTime:0.156024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277760 ORDER BY `minOrder` ASC [ RunTime:0.066003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277760 ORDER BY `unit` DESC [ RunTime:0.140554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277760 LIMIT 2 [ RunTime:0.105357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277760 ORDER BY `minOrder` ASC [ RunTime:0.033709s ]
select * from pdf where partno='2106751-3' and brandshort='te connectivity' limit 1 [ RunTime:0.025525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106751-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.099354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163258 LIMIT 4 [ RunTime:0.089944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163258 ORDER BY `minOrder` ASC [ RunTime:0.152897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163258 ORDER BY `unit` DESC [ RunTime:0.093386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163258 LIMIT 2 [ RunTime:0.174359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163258 ORDER BY `minOrder` ASC [ RunTime:0.122681s ]
select * from pdf where partno='2106751-3' and brandshort='te connectivity' limit 1 [ RunTime:0.051107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106751-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34357521 LIMIT 4 [ RunTime:0.079627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34357521 ORDER BY `minOrder` ASC [ RunTime:0.217513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34357521 ORDER BY `unit` DESC [ RunTime:0.077290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34357521 LIMIT 2 [ RunTime:0.088500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34357521 ORDER BY `minOrder` ASC [ RunTime:0.044359s ]
select * from pdf where partno='21003211-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.089608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21003211-01' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.027247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519934 LIMIT 4 [ RunTime:0.166973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519934 ORDER BY `minOrder` ASC [ RunTime:0.063867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519934 ORDER BY `unit` DESC [ RunTime:0.200198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519934 LIMIT 2 [ RunTime:0.092881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519934 ORDER BY `minOrder` ASC [ RunTime:0.032359s ]
select * from pdf where partno='2101-3-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.085520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277492 LIMIT 4 [ RunTime:0.087108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277492 ORDER BY `minOrder` ASC [ RunTime:0.057241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277492 ORDER BY `unit` DESC [ RunTime:0.077641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277492 LIMIT 2 [ RunTime:0.085153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277492 ORDER BY `minOrder` ASC [ RunTime:0.130140s ]
select * from pdf where partno='2106489-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.059944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106489-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.032440s ]
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.012854s ]