SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001088s ]
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.001661s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001109s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001703s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001480s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001198s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.008311s ]
UPDATE `stock_search` SET `count` = 3966 , `updatetime` = '2026-06-08 15:56:56' WHERE `partno` = '210' [ RunTime:0.007610s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000734s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004357s ]
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.000834s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002157s ]
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.000502s ]
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 2900,20 [ RunTime:0.058800s ]
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 ('36853301','36852903','36852902','36852376','36851850','36850787','36850569','36849108','36839165','36839038','36838997','36838946','36838932','36832901','36832792','36832791','36832790','36832789','36832788','36832787') ORDER BY FIELD(s.id, 36853301,36852903,36852902,36852376,36851850,36850787,36850569,36849108,36839165,36839038,36838997,36838946,36838932,36832901,36832792,36832791,36832790,36832789,36832788,36832787) [ RunTime:0.021944s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36853301 LIMIT 4 [ RunTime:0.013286s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36853301 ORDER BY `minOrder` ASC [ RunTime:0.026956s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36853301 ORDER BY `unit` DESC [ RunTime:0.013223s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36853301 LIMIT 2 [ RunTime:0.004200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36853301 ORDER BY `minOrder` ASC [ RunTime:0.000915s ]
select * from pdf where partno='21070120' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.008121s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21070120' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.045463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36852903 LIMIT 4 [ RunTime:0.039429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36852903 ORDER BY `minOrder` ASC [ RunTime:0.007335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36852903 ORDER BY `unit` DESC [ RunTime:0.020777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36852903 LIMIT 2 [ RunTime:0.029223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36852903 ORDER BY `minOrder` ASC [ RunTime:0.015007s ]
select * from pdf where partno='21070124' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.020953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21070124' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.014452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36852902 LIMIT 4 [ RunTime:0.030498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36852902 ORDER BY `minOrder` ASC [ RunTime:0.011031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36852902 ORDER BY `unit` DESC [ RunTime:0.023247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36852902 LIMIT 2 [ RunTime:0.020233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36852902 ORDER BY `minOrder` ASC [ RunTime:0.013106s ]
select * from pdf where partno='21070125' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.017891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21070125' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.039460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36852376 LIMIT 4 [ RunTime:0.040504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36852376 ORDER BY `minOrder` ASC [ RunTime:0.019119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36852376 ORDER BY `unit` DESC [ RunTime:0.136372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36852376 LIMIT 2 [ RunTime:0.049446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36852376 ORDER BY `minOrder` ASC [ RunTime:0.030545s ]
select * from pdf where partno='21070100' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.195590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21070100' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.101639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36851850 LIMIT 4 [ RunTime:0.188746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36851850 ORDER BY `minOrder` ASC [ RunTime:0.105146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36851850 ORDER BY `unit` DESC [ RunTime:0.125215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36851850 LIMIT 2 [ RunTime:0.032677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36851850 ORDER BY `minOrder` ASC [ RunTime:0.011987s ]
select * from pdf where partno='21070101' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.016067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21070101' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.025238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36850787 LIMIT 4 [ RunTime:0.132619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36850787 ORDER BY `minOrder` ASC [ RunTime:0.117920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36850787 ORDER BY `unit` DESC [ RunTime:0.072606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36850787 LIMIT 2 [ RunTime:0.050669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36850787 ORDER BY `minOrder` ASC [ RunTime:0.029837s ]
select * from pdf where partno='21070102' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.096515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21070102' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.105505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36850569 LIMIT 4 [ RunTime:0.017254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36850569 ORDER BY `minOrder` ASC [ RunTime:0.023381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36850569 ORDER BY `unit` DESC [ RunTime:0.037000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36850569 LIMIT 2 [ RunTime:0.028563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36850569 ORDER BY `minOrder` ASC [ RunTime:0.002003s ]
select * from pdf where partno='21070103' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.005190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21070103' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.012205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36849108 LIMIT 4 [ RunTime:0.046141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36849108 ORDER BY `minOrder` ASC [ RunTime:0.008088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36849108 ORDER BY `unit` DESC [ RunTime:0.017128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36849108 LIMIT 2 [ RunTime:0.015862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36849108 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
select * from pdf where partno='21079000' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.007843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21079000' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.009764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36839165 LIMIT 4 [ RunTime:0.015219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36839165 ORDER BY `minOrder` ASC [ RunTime:0.012290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36839165 ORDER BY `unit` DESC [ RunTime:0.019728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36839165 LIMIT 2 [ RunTime:0.029052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36839165 ORDER BY `minOrder` ASC [ RunTime:0.056391s ]
select * from pdf where partno='2107R' and brandshort='Serpac' limit 1 [ RunTime:0.012059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107R' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.021085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36839038 LIMIT 4 [ RunTime:0.025863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36839038 ORDER BY `minOrder` ASC [ RunTime:0.003868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36839038 ORDER BY `unit` DESC [ RunTime:0.001600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36839038 LIMIT 2 [ RunTime:0.003478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36839038 ORDER BY `minOrder` ASC [ RunTime:0.007608s ]
select * from pdf where partno='2107,CL' and brandshort='Serpac' limit 1 [ RunTime:0.006313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107,CL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.018118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36838997 LIMIT 4 [ RunTime:0.016874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36838997 ORDER BY `minOrder` ASC [ RunTime:0.012394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36838997 ORDER BY `unit` DESC [ RunTime:0.013851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36838997 LIMIT 2 [ RunTime:0.021575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36838997 ORDER BY `minOrder` ASC [ RunTime:0.005777s ]
select * from pdf where partno='2106,CL' and brandshort='Serpac' limit 1 [ RunTime:0.037203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106,CL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.008566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36838946 LIMIT 4 [ RunTime:0.005126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36838946 ORDER BY `minOrder` ASC [ RunTime:0.015687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36838946 ORDER BY `unit` DESC [ RunTime:0.010342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36838946 LIMIT 2 [ RunTime:0.011950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36838946 ORDER BY `minOrder` ASC [ RunTime:0.006924s ]
select * from pdf where partno='2106, CL' and brandshort='Serpac' limit 1 [ RunTime:0.005220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106, CL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.009650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36838932 LIMIT 4 [ RunTime:0.008514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36838932 ORDER BY `minOrder` ASC [ RunTime:0.022034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36838932 ORDER BY `unit` DESC [ RunTime:0.014505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36838932 LIMIT 2 [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36838932 ORDER BY `minOrder` ASC [ RunTime:0.002473s ]
select * from pdf where partno='2105, CL' and brandshort='Serpac' limit 1 [ RunTime:0.000827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105, CL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.028058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832901 LIMIT 4 [ RunTime:0.047702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832901 ORDER BY `minOrder` ASC [ RunTime:0.044894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832901 ORDER BY `unit` DESC [ RunTime:0.012301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832901 LIMIT 2 [ RunTime:0.004460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832901 ORDER BY `minOrder` ASC [ RunTime:0.001392s ]
select * from pdf where partno='2105, AL' and brandshort='Serpac' limit 1 [ RunTime:0.005434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105, AL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.036678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832792 LIMIT 4 [ RunTime:0.026700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832792 ORDER BY `minOrder` ASC [ RunTime:0.033493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832792 ORDER BY `unit` DESC [ RunTime:0.033654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832792 LIMIT 2 [ RunTime:0.000910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832792 ORDER BY `minOrder` ASC [ RunTime:0.021872s ]
select * from pdf where partno='2104, BK' and brandshort='Serpac' limit 1 [ RunTime:0.018582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104, BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.033173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832791 LIMIT 4 [ RunTime:0.015953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832791 ORDER BY `minOrder` ASC [ RunTime:0.012695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832791 ORDER BY `unit` DESC [ RunTime:0.018390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832791 LIMIT 2 [ RunTime:0.023115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832791 ORDER BY `minOrder` ASC [ RunTime:0.015008s ]
select * from pdf where partno='2104, AL' and brandshort='Serpac' limit 1 [ RunTime:0.007198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104, AL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.005598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832790 LIMIT 4 [ RunTime:0.031916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832790 ORDER BY `minOrder` ASC [ RunTime:0.014062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832790 ORDER BY `unit` DESC [ RunTime:0.009253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832790 LIMIT 2 [ RunTime:0.025808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832790 ORDER BY `minOrder` ASC [ RunTime:0.007179s ]
select * from pdf where partno='2105, GY' and brandshort='Serpac' limit 1 [ RunTime:0.014981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105, GY' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.024435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832789 LIMIT 4 [ RunTime:0.017558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832789 ORDER BY `minOrder` ASC [ RunTime:0.019835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832789 ORDER BY `unit` DESC [ RunTime:0.022214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832789 LIMIT 2 [ RunTime:0.004010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832789 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='2107, BK' and brandshort='Serpac' limit 1 [ RunTime:0.005951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107, BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.012169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832788 LIMIT 4 [ RunTime:0.029576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832788 ORDER BY `minOrder` ASC [ RunTime:0.049530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832788 ORDER BY `unit` DESC [ RunTime:0.054535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832788 LIMIT 2 [ RunTime:0.012186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832788 ORDER BY `minOrder` ASC [ RunTime:0.035576s ]
select * from pdf where partno='2106, GY' and brandshort='Serpac' limit 1 [ RunTime:0.039769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106, GY' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.088606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36832787 LIMIT 4 [ RunTime:0.002335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832787 ORDER BY `minOrder` ASC [ RunTime:0.003979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36832787 ORDER BY `unit` DESC [ RunTime:0.010432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36832787 LIMIT 2 [ RunTime:0.000805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36832787 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='2104, GY' and brandshort='Serpac' limit 1 [ RunTime:0.016394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104, GY' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.016965s ]
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.003632s ]