SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001308s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=5006&search=1' [ RunTime:0.005463s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001255s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002525s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002599s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.004812s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001038s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002063s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001150s ]
SELECT * FROM `stock_search` WHERE `partno` = '5006' LIMIT 1 [ RunTime:0.044387s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-17 21:02:20' WHERE `partno` = '5006' [ RunTime:0.025955s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001685s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046705s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13899493 LIMIT 5 [ RunTime:0.030318s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13899493 ORDER BY `minOrder` ASC [ RunTime:0.023632s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13899493 ORDER BY `unit` DESC [ RunTime:0.010853s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13899493 LIMIT 2 [ RunTime:0.032330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13899493 ORDER BY `minOrder` ASC [ RunTime:0.005776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484387 LIMIT 5 [ RunTime:0.013844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484387 ORDER BY `minOrder` ASC [ RunTime:0.026624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484387 ORDER BY `unit` DESC [ RunTime:0.024854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484387 LIMIT 2 [ RunTime:0.016981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484387 ORDER BY `minOrder` ASC [ RunTime:0.045837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484278 LIMIT 5 [ RunTime:0.031158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484278 ORDER BY `minOrder` ASC [ RunTime:0.011318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484278 ORDER BY `unit` DESC [ RunTime:0.070584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484278 LIMIT 2 [ RunTime:0.023650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484278 ORDER BY `minOrder` ASC [ RunTime:0.029758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613131 LIMIT 5 [ RunTime:0.021422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613131 ORDER BY `minOrder` ASC [ RunTime:0.021363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613131 ORDER BY `unit` DESC [ RunTime:0.039306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613131 LIMIT 2 [ RunTime:0.016941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613131 ORDER BY `minOrder` ASC [ RunTime:0.037211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612900 LIMIT 5 [ RunTime:0.028726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612900 ORDER BY `minOrder` ASC [ RunTime:0.052536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612900 ORDER BY `unit` DESC [ RunTime:0.061781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612900 LIMIT 2 [ RunTime:0.035943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612900 ORDER BY `minOrder` ASC [ RunTime:0.019989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484723 LIMIT 5 [ RunTime:0.022288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484723 ORDER BY `minOrder` ASC [ RunTime:0.016135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484723 ORDER BY `unit` DESC [ RunTime:0.011487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484723 LIMIT 2 [ RunTime:0.032671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484723 ORDER BY `minOrder` ASC [ RunTime:0.005031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484716 LIMIT 5 [ RunTime:0.018529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484716 ORDER BY `minOrder` ASC [ RunTime:0.007012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484716 ORDER BY `unit` DESC [ RunTime:0.013478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484716 LIMIT 2 [ RunTime:0.012196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484716 ORDER BY `minOrder` ASC [ RunTime:0.006835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612892 LIMIT 5 [ RunTime:0.011738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612892 ORDER BY `minOrder` ASC [ RunTime:0.000999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612892 ORDER BY `unit` DESC [ RunTime:0.006768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612892 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612892 ORDER BY `minOrder` ASC [ RunTime:0.003073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6119 LIMIT 5 [ RunTime:0.002032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6119 ORDER BY `minOrder` ASC [ RunTime:0.003964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6119 ORDER BY `unit` DESC [ RunTime:0.005530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6119 LIMIT 2 [ RunTime:0.001437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6119 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006' OR `brand` LIKE 'KEYSTONE%' ) ) LIMIT 1 [ RunTime:0.000362s ]
SELECT `id` FROM `stock` WHERE `id` <> 6119 AND `partno` = '5006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13899493 [ RunTime:0.000539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612911 LIMIT 5 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612911 ORDER BY `minOrder` ASC [ RunTime:0.002301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612911 ORDER BY `unit` DESC [ RunTime:0.004758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612911 LIMIT 2 [ RunTime:0.002357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612911 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484722 LIMIT 5 [ RunTime:0.003086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484722 ORDER BY `minOrder` ASC [ RunTime:0.005403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484722 ORDER BY `unit` DESC [ RunTime:0.003641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484722 LIMIT 2 [ RunTime:0.005562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484722 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182695 LIMIT 5 [ RunTime:0.004411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182695 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182695 ORDER BY `unit` DESC [ RunTime:0.000360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182695 LIMIT 2 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182695 ORDER BY `minOrder` ASC [ RunTime:0.002875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182693 LIMIT 5 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182693 ORDER BY `minOrder` ASC [ RunTime:0.007695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182693 ORDER BY `unit` DESC [ RunTime:0.008011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182693 LIMIT 2 [ RunTime:0.009817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182693 ORDER BY `minOrder` ASC [ RunTime:0.007525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182690 LIMIT 5 [ RunTime:0.003154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182690 ORDER BY `minOrder` ASC [ RunTime:0.002311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182690 ORDER BY `unit` DESC [ RunTime:0.000359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182690 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182690 ORDER BY `minOrder` ASC [ RunTime:0.003171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194892 LIMIT 5 [ RunTime:0.003009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194892 ORDER BY `minOrder` ASC [ RunTime:0.009748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11194892 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11194892 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194892 ORDER BY `minOrder` ASC [ RunTime:0.001998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194891 LIMIT 5 [ RunTime:0.006163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194891 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11194891 ORDER BY `unit` DESC [ RunTime:0.008510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11194891 LIMIT 2 [ RunTime:0.008047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194891 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389586 LIMIT 5 [ RunTime:0.002590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389586 ORDER BY `minOrder` ASC [ RunTime:0.005823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389586 ORDER BY `unit` DESC [ RunTime:0.000485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389586 LIMIT 2 [ RunTime:0.004955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389586 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
select * from pdf where partno='5006C SL324' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373488 LIMIT 5 [ RunTime:0.003566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373488 ORDER BY `minOrder` ASC [ RunTime:0.004587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13373488 ORDER BY `unit` DESC [ RunTime:0.009851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13373488 LIMIT 2 [ RunTime:0.012007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373488 ORDER BY `minOrder` ASC [ RunTime:0.001677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11409512 LIMIT 5 [ RunTime:0.001423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409512 ORDER BY `minOrder` ASC [ RunTime:0.003643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11409512 ORDER BY `unit` DESC [ RunTime:0.002476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11409512 LIMIT 2 [ RunTime:0.007127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409512 ORDER BY `minOrder` ASC [ RunTime:0.016285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12454154 LIMIT 5 [ RunTime:0.019768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12454154 ORDER BY `minOrder` ASC [ RunTime:0.012399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12454154 ORDER BY `unit` DESC [ RunTime:0.007671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12454154 LIMIT 2 [ RunTime:0.008257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12454154 ORDER BY `minOrder` ASC [ RunTime:0.002673s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277030 LIMIT 5 [ RunTime:0.013881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277030 ORDER BY `minOrder` ASC [ RunTime:0.009317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277030 ORDER BY `unit` DESC [ RunTime:0.011816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277030 LIMIT 2 [ RunTime:0.027494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277030 ORDER BY `minOrder` ASC [ RunTime:0.004587s ]
select * from pdf where partno='500638-0507' and brandshort='molex' limit 1 [ RunTime:0.029294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '500638-0507' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.022241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255150 LIMIT 5 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255150 ORDER BY `minOrder` ASC [ RunTime:0.016731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255150 ORDER BY `unit` DESC [ RunTime:0.015754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255150 LIMIT 2 [ RunTime:0.019015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255150 ORDER BY `minOrder` ASC [ RunTime:0.006407s ]
select * from pdf where partno='500654-0609' and brandshort='molex' limit 1 [ RunTime:0.010382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '500654-0609' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.032917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254725 LIMIT 5 [ RunTime:0.008208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254725 ORDER BY `minOrder` ASC [ RunTime:0.021813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254725 ORDER BY `unit` DESC [ RunTime:0.001798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254725 LIMIT 2 [ RunTime:0.007919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254725 ORDER BY `minOrder` ASC [ RunTime:0.003240s ]
select * from pdf where partno='500655-0619' and brandshort='molex' limit 1 [ RunTime:0.001332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '500655-0619' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.025930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255284 LIMIT 5 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255284 ORDER BY `minOrder` ASC [ RunTime:0.016854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255284 ORDER BY `unit` DESC [ RunTime:0.012629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255284 LIMIT 2 [ RunTime:0.009425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255284 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
select * from pdf where partno='500655-0609' and brandshort='molex' limit 1 [ RunTime:0.010153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '500655-0609' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137241 LIMIT 5 [ RunTime:0.048860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137241 ORDER BY `minOrder` ASC [ RunTime:0.019082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137241 ORDER BY `unit` DESC [ RunTime:0.016074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137241 LIMIT 2 [ RunTime:0.004890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137241 ORDER BY `minOrder` ASC [ RunTime:0.003586s ]
select * from pdf where partno='5006c sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.016749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006c sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.033673s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137241 AND `partno` = '5006c sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.027926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513111 [ RunTime:0.030446s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63503853 LIMIT 5 [ RunTime:0.075012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503853 ORDER BY `minOrder` ASC [ RunTime:0.062176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63503853 ORDER BY `unit` DESC [ RunTime:0.029515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63503853 LIMIT 2 [ RunTime:0.075718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503853 ORDER BY `minOrder` ASC [ RunTime:0.009260s ]
select * from pdf where partno='5006' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.034269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.021587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62121549 LIMIT 5 [ RunTime:0.024326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121549 ORDER BY `minOrder` ASC [ RunTime:0.050463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62121549 ORDER BY `unit` DESC [ RunTime:0.033131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62121549 LIMIT 2 [ RunTime:0.011602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121549 ORDER BY `minOrder` ASC [ RunTime:0.041926s ]
select * from pdf where partno='500654-0619' and brandshort='Molex' limit 1 [ RunTime:0.022589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '500654-0619' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.069559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362191 LIMIT 5 [ RunTime:0.039515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362191 ORDER BY `minOrder` ASC [ RunTime:0.036332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362191 ORDER BY `unit` DESC [ RunTime:0.064453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362191 LIMIT 2 [ RunTime:0.039510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362191 ORDER BY `minOrder` ASC [ RunTime:0.044590s ]
select * from pdf where partno='5006381007' and brandshort='Molex' limit 1 [ RunTime:0.051230s ]
select foldpath,foldpath2,filename from pdf_file where id=1684545 limit 1 [ RunTime:0.065980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006381007' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.022840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60364042 LIMIT 5 [ RunTime:0.022994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60364042 ORDER BY `minOrder` ASC [ RunTime:0.009638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60364042 ORDER BY `unit` DESC [ RunTime:0.016379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60364042 LIMIT 2 [ RunTime:0.019917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60364042 ORDER BY `minOrder` ASC [ RunTime:0.003790s ]
select * from pdf where partno='500638-1007' and brandshort='Molex' limit 1 [ RunTime:0.000562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '500638-1007' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361526 LIMIT 5 [ RunTime:0.038269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361526 ORDER BY `minOrder` ASC [ RunTime:0.005753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361526 ORDER BY `unit` DESC [ RunTime:0.002506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361526 LIMIT 2 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361526 ORDER BY `minOrder` ASC [ RunTime:0.004921s ]
select * from pdf where partno='5006380407' and brandshort='Molex' limit 1 [ RunTime:0.008646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006380407' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.040550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362238 LIMIT 5 [ RunTime:0.022286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362238 ORDER BY `minOrder` ASC [ RunTime:0.014433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362238 ORDER BY `unit` DESC [ RunTime:0.009343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362238 LIMIT 2 [ RunTime:0.003848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362238 ORDER BY `minOrder` ASC [ RunTime:0.004555s ]
select * from pdf where partno='5006381807' and brandshort='Molex' limit 1 [ RunTime:0.002184s ]
select foldpath,foldpath2,filename from pdf_file where id=1870833 limit 1 [ RunTime:0.002437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006381807' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.040183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362192 LIMIT 5 [ RunTime:0.006126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362192 ORDER BY `minOrder` ASC [ RunTime:0.003967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362192 ORDER BY `unit` DESC [ RunTime:0.005816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362192 LIMIT 2 [ RunTime:0.001243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362192 ORDER BY `minOrder` ASC [ RunTime:0.004758s ]
select * from pdf where partno='5006380907' and brandshort='Molex' limit 1 [ RunTime:0.001257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006380907' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361541 LIMIT 5 [ RunTime:0.017960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361541 ORDER BY `minOrder` ASC [ RunTime:0.006485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361541 ORDER BY `unit` DESC [ RunTime:0.017708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361541 LIMIT 2 [ RunTime:0.011478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361541 ORDER BY `minOrder` ASC [ RunTime:0.011019s ]
select * from pdf where partno='5006380507' and brandshort='Molex' limit 1 [ RunTime:0.001319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006380507' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.026078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362199 LIMIT 5 [ RunTime:0.013303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362199 ORDER BY `minOrder` ASC [ RunTime:0.001320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362199 ORDER BY `unit` DESC [ RunTime:0.015306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362199 LIMIT 2 [ RunTime:0.018966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362199 ORDER BY `minOrder` ASC [ RunTime:0.012802s ]
select * from pdf where partno='5006381307' and brandshort='Molex' limit 1 [ RunTime:0.008269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006381307' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.022575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361565 LIMIT 5 [ RunTime:0.005818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361565 ORDER BY `minOrder` ASC [ RunTime:0.009358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361565 ORDER BY `unit` DESC [ RunTime:0.004703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361565 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361565 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='5006381207' and brandshort='Molex' limit 1 [ RunTime:0.000924s ]
select foldpath,foldpath2,filename from pdf_file where id=1791062 limit 1 [ RunTime:0.002274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006381207' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361534 LIMIT 5 [ RunTime:0.002252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361534 ORDER BY `minOrder` ASC [ RunTime:0.009024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361534 ORDER BY `unit` DESC [ RunTime:0.008170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361534 LIMIT 2 [ RunTime:0.005627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361534 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
select * from pdf where partno='5006380607' and brandshort='Molex' limit 1 [ RunTime:0.000509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006380607' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362207 LIMIT 5 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362207 ORDER BY `minOrder` ASC [ RunTime:0.001545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362207 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362207 LIMIT 2 [ RunTime:0.007526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362207 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='5006381507' and brandshort='Molex' limit 1 [ RunTime:0.003956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006381507' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362198 LIMIT 5 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362198 ORDER BY `minOrder` ASC [ RunTime:0.004500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362198 ORDER BY `unit` DESC [ RunTime:0.005194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362198 LIMIT 2 [ RunTime:0.002280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362198 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='5006381107' and brandshort='Molex' limit 1 [ RunTime:0.000926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006381107' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361545 LIMIT 5 [ RunTime:0.001557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361545 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361545 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361545 LIMIT 2 [ RunTime:0.002770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361545 ORDER BY `minOrder` ASC [ RunTime:0.005949s ]
select * from pdf where partno='5006380807' and brandshort='Molex' limit 1 [ RunTime:0.003576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006380807' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62996759 LIMIT 5 [ RunTime:0.001371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62996759 ORDER BY `minOrder` ASC [ RunTime:0.001135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62996759 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62996759 LIMIT 2 [ RunTime:0.007538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62996759 ORDER BY `minOrder` ASC [ RunTime:0.018516s ]
select * from pdf where partno='5006C SL324' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006C SL324' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.015283s ]
SELECT `id` FROM `stock` WHERE `id` <> 62996759 AND `partno` = '5006C SL324' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.012543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389586 [ RunTime:0.005798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60374180 LIMIT 5 [ RunTime:0.003739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374180 ORDER BY `minOrder` ASC [ RunTime:0.013749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60374180 ORDER BY `unit` DESC [ RunTime:0.006718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60374180 LIMIT 2 [ RunTime:0.002302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374180 ORDER BY `minOrder` ASC [ RunTime:0.014832s ]
select * from pdf where partno='5006540609' and brandshort='Molex' limit 1 [ RunTime:0.018565s ]
select foldpath,foldpath2,filename from pdf_file where id=1912638 limit 1 [ RunTime:0.049911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5006540609' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546020 LIMIT 5 [ RunTime:0.016111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546020 ORDER BY `minOrder` ASC [ RunTime:0.025822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546020 ORDER BY `unit` DESC [ RunTime:0.009347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546020 LIMIT 2 [ RunTime:0.005841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546020 ORDER BY `minOrder` ASC [ RunTime:0.001585s ]
select * from pdf where partno='50066' and brandshort='Excel Blades' limit 1 [ RunTime:0.004957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50066' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.014947s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546020 AND `partno` = '50066' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.018957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194892 [ RunTime:0.016456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546018 LIMIT 5 [ RunTime:0.012658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546018 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546018 ORDER BY `unit` DESC [ RunTime:0.032920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546018 LIMIT 2 [ RunTime:0.011041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546018 ORDER BY `minOrder` ASC [ RunTime:0.005290s ]
select * from pdf where partno='50069' and brandshort='Excel Blades' limit 1 [ RunTime:0.006099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50069' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.030128s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546018 AND `partno` = '50069' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.009913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194891 [ RunTime:0.034408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546016 LIMIT 5 [ RunTime:0.022123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546016 ORDER BY `minOrder` ASC [ RunTime:0.055229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546016 ORDER BY `unit` DESC [ RunTime:0.016405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546016 LIMIT 2 [ RunTime:0.012651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546016 ORDER BY `minOrder` ASC [ RunTime:0.003424s ]
select * from pdf where partno='50068' and brandshort='Excel Blades' limit 1 [ RunTime:0.033175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50068' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.018800s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546016 AND `partno` = '50068' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182695 [ RunTime:0.003233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546013 LIMIT 5 [ RunTime:0.006781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546013 ORDER BY `minOrder` ASC [ RunTime:0.018972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546013 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546013 LIMIT 2 [ RunTime:0.032038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546013 ORDER BY `minOrder` ASC [ RunTime:0.022186s ]
select * from pdf where partno='50067' and brandshort='Excel Blades' limit 1 [ RunTime:0.016602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50067' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.033484s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546013 AND `partno` = '50067' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.023891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182693 [ RunTime:0.018407s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061943s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035386s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016921s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007340s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001183s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031275s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51020086 LIMIT 5 [ RunTime:0.015076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51020086 ORDER BY `minOrder` ASC [ RunTime:0.014610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51020086 ORDER BY `unit` DESC [ RunTime:0.007393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51020086 LIMIT 2 [ RunTime:0.022329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51020086 ORDER BY `minOrder` ASC [ RunTime:0.003921s ]
select * from pdf where partno='500600-1001131' and brandshort='cenreon' limit 1 [ RunTime:0.010701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '500600-1001131' OR `brand` LIKE 'cenreon(讯联汇通)%' ) ) LIMIT 1 [ RunTime:0.015240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51020447 LIMIT 5 [ RunTime:0.004422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51020447 ORDER BY `minOrder` ASC [ RunTime:0.025470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51020447 ORDER BY `unit` DESC [ RunTime:0.007758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51020447 LIMIT 2 [ RunTime:0.024212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51020447 ORDER BY `minOrder` ASC [ RunTime:0.003142s ]
select * from pdf where partno='500600-1001121' and brandshort='cenreon' limit 1 [ RunTime:0.010792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '500600-1001121' OR `brand` LIKE 'cenreon(讯联汇通)%' ) ) LIMIT 1 [ RunTime:0.002009s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5006%' OR `brand` LIKE '5006%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010761s ]