SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001589s ]
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.006556s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002167s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004497s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001518s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.003144s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001438s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003460s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001389s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.025538s ]
UPDATE `stock_search` SET `count` = 4183 , `updatetime` = '2026-06-08 16:54:48' WHERE `partno` = '210' [ RunTime:0.020880s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.006904s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001326s ]
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.000533s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001699s ]
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.000794s ]
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 2860,20 [ RunTime:0.076920s ]
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 ('37558179','37558176','37558175','37558174','37558173','37558172','37558171','37558170','37558167','37558166','37558165','37558164','37558163','37558162','37556141','37550143','37549937','37549929','37549899','37549894') ORDER BY FIELD(s.id, 37558179,37558176,37558175,37558174,37558173,37558172,37558171,37558170,37558167,37558166,37558165,37558164,37558163,37558162,37556141,37550143,37549937,37549929,37549899,37549894) [ RunTime:0.005853s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558179 LIMIT 4 [ RunTime:0.000929s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558179 ORDER BY `minOrder` ASC [ RunTime:0.007610s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558179 ORDER BY `unit` DESC [ RunTime:0.004088s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558179 LIMIT 2 [ RunTime:0.003654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558179 ORDER BY `minOrder` ASC [ RunTime:0.006618s ]
select * from pdf where partno='210002825' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.007417s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002825' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.003174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558176 LIMIT 4 [ RunTime:0.002562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558176 ORDER BY `minOrder` ASC [ RunTime:0.002549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558176 ORDER BY `unit` DESC [ RunTime:0.006245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558176 LIMIT 2 [ RunTime:0.016552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558176 ORDER BY `minOrder` ASC [ RunTime:0.006086s ]
select * from pdf where partno='210002832' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.010143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002832' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.028674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558175 LIMIT 4 [ RunTime:0.024354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558175 ORDER BY `minOrder` ASC [ RunTime:0.022512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558175 ORDER BY `unit` DESC [ RunTime:0.010445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558175 LIMIT 2 [ RunTime:0.014470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558175 ORDER BY `minOrder` ASC [ RunTime:0.009194s ]
select * from pdf where partno='210002833' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002833' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.012982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558174 LIMIT 4 [ RunTime:0.016909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558174 ORDER BY `minOrder` ASC [ RunTime:0.035914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558174 ORDER BY `unit` DESC [ RunTime:0.015917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558174 LIMIT 2 [ RunTime:0.013038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558174 ORDER BY `minOrder` ASC [ RunTime:0.013783s ]
select * from pdf where partno='210002837' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.008168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002837' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.013972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558173 LIMIT 4 [ RunTime:0.010433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558173 ORDER BY `minOrder` ASC [ RunTime:0.004370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558173 ORDER BY `unit` DESC [ RunTime:0.011670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558173 LIMIT 2 [ RunTime:0.004036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558173 ORDER BY `minOrder` ASC [ RunTime:0.013142s ]
select * from pdf where partno='210002836' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.009103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002836' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558172 LIMIT 4 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558172 ORDER BY `minOrder` ASC [ RunTime:0.005407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558172 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558172 LIMIT 2 [ RunTime:0.002080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558172 ORDER BY `minOrder` ASC [ RunTime:0.001221s ]
select * from pdf where partno='210002838' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002838' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558171 LIMIT 4 [ RunTime:0.022522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558171 ORDER BY `minOrder` ASC [ RunTime:0.010654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558171 ORDER BY `unit` DESC [ RunTime:0.011637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558171 LIMIT 2 [ RunTime:0.014358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558171 ORDER BY `minOrder` ASC [ RunTime:0.008924s ]
select * from pdf where partno='210002835' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.004219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002835' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.009210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558170 LIMIT 4 [ RunTime:0.027574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558170 ORDER BY `minOrder` ASC [ RunTime:0.022836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558170 ORDER BY `unit` DESC [ RunTime:0.000973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558170 LIMIT 2 [ RunTime:0.017490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558170 ORDER BY `minOrder` ASC [ RunTime:0.020843s ]
select * from pdf where partno='210002834' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.009628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002834' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.011996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558167 LIMIT 4 [ RunTime:0.014921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558167 ORDER BY `minOrder` ASC [ RunTime:0.001240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558167 ORDER BY `unit` DESC [ RunTime:0.003888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558167 LIMIT 2 [ RunTime:0.012647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558167 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
select * from pdf where partno='210002746' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.002239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002746' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.001724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558166 LIMIT 4 [ RunTime:0.002995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558166 ORDER BY `minOrder` ASC [ RunTime:0.007693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558166 ORDER BY `unit` DESC [ RunTime:0.008302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558166 LIMIT 2 [ RunTime:0.009144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558166 ORDER BY `minOrder` ASC [ RunTime:0.006858s ]
select * from pdf where partno='210002745' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.003689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002745' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.003820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558165 LIMIT 4 [ RunTime:0.004618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558165 ORDER BY `minOrder` ASC [ RunTime:0.016332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558165 ORDER BY `unit` DESC [ RunTime:0.001436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558165 LIMIT 2 [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558165 ORDER BY `minOrder` ASC [ RunTime:0.005922s ]
select * from pdf where partno='210002744' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.003097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002744' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.017064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558164 LIMIT 4 [ RunTime:0.023426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558164 ORDER BY `minOrder` ASC [ RunTime:0.061765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558164 ORDER BY `unit` DESC [ RunTime:0.037591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558164 LIMIT 2 [ RunTime:0.025700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558164 ORDER BY `minOrder` ASC [ RunTime:0.010682s ]
select * from pdf where partno='210002742' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.026604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002742' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.021052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558163 LIMIT 4 [ RunTime:0.044275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558163 ORDER BY `minOrder` ASC [ RunTime:0.011412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558163 ORDER BY `unit` DESC [ RunTime:0.014241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558163 LIMIT 2 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558163 ORDER BY `minOrder` ASC [ RunTime:0.002491s ]
select * from pdf where partno='210002741' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.009042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002741' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.015308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558162 LIMIT 4 [ RunTime:0.002236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558162 ORDER BY `minOrder` ASC [ RunTime:0.007455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558162 ORDER BY `unit` DESC [ RunTime:0.010886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558162 LIMIT 2 [ RunTime:0.019549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558162 ORDER BY `minOrder` ASC [ RunTime:0.011397s ]
select * from pdf where partno='210002743' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.022534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002743' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.025997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37556141 LIMIT 4 [ RunTime:0.020700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37556141 ORDER BY `minOrder` ASC [ RunTime:0.023025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37556141 ORDER BY `unit` DESC [ RunTime:0.048111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37556141 LIMIT 2 [ RunTime:0.018853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37556141 ORDER BY `minOrder` ASC [ RunTime:0.022592s ]
select * from pdf where partno='2100BL15A0100001E' and brandshort='Johanson Technology Inc.' limit 1 [ RunTime:0.021544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100BL15A0100001E' OR `brand` LIKE 'Johanson Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.027730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37550143 LIMIT 4 [ RunTime:0.015058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37550143 ORDER BY `minOrder` ASC [ RunTime:0.026390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37550143 ORDER BY `unit` DESC [ RunTime:0.029839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37550143 LIMIT 2 [ RunTime:0.003800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37550143 ORDER BY `minOrder` ASC [ RunTime:0.003048s ]
select * from pdf where partno='210000377' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.012503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000377' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.037598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549937 LIMIT 4 [ RunTime:0.021482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549937 ORDER BY `minOrder` ASC [ RunTime:0.036845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549937 ORDER BY `unit` DESC [ RunTime:0.007225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549937 LIMIT 2 [ RunTime:0.009889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549937 ORDER BY `minOrder` ASC [ RunTime:0.004483s ]
select * from pdf where partno='210003065' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.006191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003065' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.012256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549929 LIMIT 4 [ RunTime:0.013210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549929 ORDER BY `minOrder` ASC [ RunTime:0.006303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549929 ORDER BY `unit` DESC [ RunTime:0.002075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549929 LIMIT 2 [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549929 ORDER BY `minOrder` ASC [ RunTime:0.002547s ]
select * from pdf where partno='210003051' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003051' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.010678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549899 LIMIT 4 [ RunTime:0.008876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549899 ORDER BY `minOrder` ASC [ RunTime:0.014867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549899 ORDER BY `unit` DESC [ RunTime:0.010989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549899 LIMIT 2 [ RunTime:0.010723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549899 ORDER BY `minOrder` ASC [ RunTime:0.004030s ]
select * from pdf where partno='210003071' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.012965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003071' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.001543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549894 LIMIT 4 [ RunTime:0.012607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549894 ORDER BY `minOrder` ASC [ RunTime:0.015131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549894 ORDER BY `unit` DESC [ RunTime:0.004913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549894 LIMIT 2 [ RunTime:0.011840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549894 ORDER BY `minOrder` ASC [ RunTime:0.002272s ]
select * from pdf where partno='210003070' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.024745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003070' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.011178s ]
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.001067s ]