SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002772s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.113' , `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=60307&search=1' [ RunTime:0.003491s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001284s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001136s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001300s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.113' ) [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001470s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001193s ]
SELECT * FROM `stock_search` WHERE `partno` = '60307' LIMIT 1 [ RunTime:0.017734s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-06 11:46:11' WHERE `partno` = '60307' [ RunTime:0.003750s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001489s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018622s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11978674 LIMIT 5 [ RunTime:0.019001s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11978674 ORDER BY `minOrder` ASC [ RunTime:0.001710s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11978674 ORDER BY `unit` DESC [ RunTime:0.001291s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11978674 LIMIT 2 [ RunTime:0.001368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11978674 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200130 LIMIT 5 [ RunTime:0.012205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200130 ORDER BY `minOrder` ASC [ RunTime:0.006601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200130 ORDER BY `unit` DESC [ RunTime:0.006113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200130 LIMIT 2 [ RunTime:0.004451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200130 ORDER BY `minOrder` ASC [ RunTime:0.002356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706903 LIMIT 5 [ RunTime:0.014351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706903 ORDER BY `minOrder` ASC [ RunTime:0.008622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14706903 ORDER BY `unit` DESC [ RunTime:0.002927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14706903 LIMIT 2 [ RunTime:0.000891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706903 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190460 LIMIT 5 [ RunTime:0.007205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190460 ORDER BY `minOrder` ASC [ RunTime:0.010517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190460 ORDER BY `unit` DESC [ RunTime:0.008107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190460 LIMIT 2 [ RunTime:0.011858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190460 ORDER BY `minOrder` ASC [ RunTime:0.011732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190459 LIMIT 5 [ RunTime:0.001800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190459 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190459 ORDER BY `unit` DESC [ RunTime:0.002338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190459 LIMIT 2 [ RunTime:0.012512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190459 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190403 LIMIT 5 [ RunTime:0.005946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190403 ORDER BY `minOrder` ASC [ RunTime:0.014168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190403 ORDER BY `unit` DESC [ RunTime:0.004981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190403 LIMIT 2 [ RunTime:0.002161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190403 ORDER BY `minOrder` ASC [ RunTime:0.006832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190402 LIMIT 5 [ RunTime:0.000830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190402 ORDER BY `minOrder` ASC [ RunTime:0.007209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190402 ORDER BY `unit` DESC [ RunTime:0.000870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190402 LIMIT 2 [ RunTime:0.006617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190402 ORDER BY `minOrder` ASC [ RunTime:0.009774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190401 LIMIT 5 [ RunTime:0.015934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190401 ORDER BY `minOrder` ASC [ RunTime:0.003372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190401 ORDER BY `unit` DESC [ RunTime:0.006164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190401 LIMIT 2 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190401 ORDER BY `minOrder` ASC [ RunTime:0.001231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200619 LIMIT 5 [ RunTime:0.020080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200619 ORDER BY `minOrder` ASC [ RunTime:0.030333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200619 ORDER BY `unit` DESC [ RunTime:0.007205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200619 LIMIT 2 [ RunTime:0.015878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200619 ORDER BY `minOrder` ASC [ RunTime:0.007155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200618 LIMIT 5 [ RunTime:0.000871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200618 ORDER BY `minOrder` ASC [ RunTime:0.010962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200618 ORDER BY `unit` DESC [ RunTime:0.007897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200618 LIMIT 2 [ RunTime:0.010700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200618 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200617 LIMIT 5 [ RunTime:0.001999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200617 ORDER BY `minOrder` ASC [ RunTime:0.018723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200617 ORDER BY `unit` DESC [ RunTime:0.008289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200617 LIMIT 2 [ RunTime:0.007882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200617 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784197 LIMIT 5 [ RunTime:0.009156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784197 ORDER BY `minOrder` ASC [ RunTime:0.004854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784197 ORDER BY `unit` DESC [ RunTime:0.003100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784197 LIMIT 2 [ RunTime:0.001678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784197 ORDER BY `minOrder` ASC [ RunTime:0.003018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784196 LIMIT 5 [ RunTime:0.006736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784196 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784196 ORDER BY `unit` DESC [ RunTime:0.006110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784196 LIMIT 2 [ RunTime:0.004942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784196 ORDER BY `minOrder` ASC [ RunTime:0.002747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781513 LIMIT 5 [ RunTime:0.003415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781513 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781513 ORDER BY `unit` DESC [ RunTime:0.001171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781513 LIMIT 2 [ RunTime:0.003503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781513 ORDER BY `minOrder` ASC [ RunTime:0.000640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781512 LIMIT 5 [ RunTime:0.001562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781512 ORDER BY `minOrder` ASC [ RunTime:0.009273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781512 ORDER BY `unit` DESC [ RunTime:0.000693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781512 LIMIT 2 [ RunTime:0.006372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781512 ORDER BY `minOrder` ASC [ RunTime:0.002574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781511 LIMIT 5 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781511 ORDER BY `minOrder` ASC [ RunTime:0.002364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781511 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781511 LIMIT 2 [ RunTime:0.007236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781511 ORDER BY `minOrder` ASC [ RunTime:0.004904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781038 LIMIT 5 [ RunTime:0.009343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781038 ORDER BY `minOrder` ASC [ RunTime:0.018226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781038 ORDER BY `unit` DESC [ RunTime:0.011335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781038 LIMIT 2 [ RunTime:0.006950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781038 ORDER BY `minOrder` ASC [ RunTime:0.008389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780367 LIMIT 5 [ RunTime:0.007951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780367 ORDER BY `minOrder` ASC [ RunTime:0.022133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780367 ORDER BY `unit` DESC [ RunTime:0.003320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780367 LIMIT 2 [ RunTime:0.009076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780367 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780366 LIMIT 5 [ RunTime:0.018851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780366 ORDER BY `minOrder` ASC [ RunTime:0.009759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780366 ORDER BY `unit` DESC [ RunTime:0.004189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780366 LIMIT 2 [ RunTime:0.020175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780366 ORDER BY `minOrder` ASC [ RunTime:0.004604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780364 LIMIT 5 [ RunTime:0.009317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780364 ORDER BY `minOrder` ASC [ RunTime:0.010927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780364 ORDER BY `unit` DESC [ RunTime:0.018988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780364 LIMIT 2 [ RunTime:0.002953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780364 ORDER BY `minOrder` ASC [ RunTime:0.013486s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32266695 LIMIT 5 [ RunTime:0.003558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266695 ORDER BY `minOrder` ASC [ RunTime:0.020051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32266695 ORDER BY `unit` DESC [ RunTime:0.031748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32266695 LIMIT 2 [ RunTime:0.031566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266695 ORDER BY `minOrder` ASC [ RunTime:0.036986s ]
select * from pdf where partno='603072' and brandshort='amphenol socapex' limit 1 [ RunTime:0.011121s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '603072' OR `brand` LIKE 'amphenol socapex%' ) ) LIMIT 1 [ RunTime:0.014045s ]
SELECT `id` FROM `stock` WHERE `id` <> 32266695 AND `partno` = '603072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol socapex%' ) [ RunTime:0.011863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339828 [ RunTime:0.010465s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339828 LIMIT 5 [ RunTime:0.020857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339828 ORDER BY `minOrder` ASC [ RunTime:0.027774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60339828 ORDER BY `unit` DESC [ RunTime:0.009940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60339828 LIMIT 2 [ RunTime:0.003531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339828 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='603072' and brandshort='Amphenol Socapex' limit 1 [ RunTime:0.022648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '603072' OR `brand` LIKE 'Amphenol Socapex%' ) ) LIMIT 1 [ RunTime:0.006509s ]
SELECT `id` FROM `stock` WHERE `id` <> 60339828 AND `partno` = '603072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol socapex%' ) [ RunTime:0.017545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32266695 [ RunTime:0.015942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63333664 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333664 ORDER BY `minOrder` ASC [ RunTime:0.021370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63333664 ORDER BY `unit` DESC [ RunTime:0.025796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63333664 LIMIT 2 [ RunTime:0.005826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333664 ORDER BY `minOrder` ASC [ RunTime:0.006049s ]
select * from pdf where partno='6030710' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030710' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015220s ]
SELECT `id` FROM `stock` WHERE `id` <> 63333664 AND `partno` = '6030710' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200130 [ RunTime:0.011449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335113 LIMIT 5 [ RunTime:0.047967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335113 ORDER BY `minOrder` ASC [ RunTime:0.016774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335113 ORDER BY `unit` DESC [ RunTime:0.021937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335113 LIMIT 2 [ RunTime:0.019473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335113 ORDER BY `minOrder` ASC [ RunTime:0.029212s ]
select * from pdf where partno='6030709' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030709' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016716s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335113 AND `partno` = '6030709' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200618 [ RunTime:0.002145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335199 LIMIT 5 [ RunTime:0.008324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335199 ORDER BY `minOrder` ASC [ RunTime:0.008550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335199 ORDER BY `unit` DESC [ RunTime:0.011077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335199 LIMIT 2 [ RunTime:0.013073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335199 ORDER BY `minOrder` ASC [ RunTime:0.007877s ]
select * from pdf where partno='6030716' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030716' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020748s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335199 AND `partno` = '6030716' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190460 [ RunTime:0.023363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335198 LIMIT 5 [ RunTime:0.012589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335198 ORDER BY `minOrder` ASC [ RunTime:0.024780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335198 ORDER BY `unit` DESC [ RunTime:0.011956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335198 LIMIT 2 [ RunTime:0.002576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335198 ORDER BY `minOrder` ASC [ RunTime:0.008938s ]
select * from pdf where partno='6030715' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030715' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.040011s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335198 AND `partno` = '6030715' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190459 [ RunTime:0.030612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335119 LIMIT 5 [ RunTime:0.011214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335119 ORDER BY `minOrder` ASC [ RunTime:0.014890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335119 ORDER BY `unit` DESC [ RunTime:0.009705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335119 LIMIT 2 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335119 ORDER BY `minOrder` ASC [ RunTime:0.003164s ]
select * from pdf where partno='6030708' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030708' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020341s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335119 AND `partno` = '6030708' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.036040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190403 [ RunTime:0.016709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335118 LIMIT 5 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335118 ORDER BY `minOrder` ASC [ RunTime:0.008924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335118 ORDER BY `unit` DESC [ RunTime:0.019126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335118 LIMIT 2 [ RunTime:0.012383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335118 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
select * from pdf where partno='6030712' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030712' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021111s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335118 AND `partno` = '6030712' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200619 [ RunTime:0.010889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335117 LIMIT 5 [ RunTime:0.045199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335117 ORDER BY `minOrder` ASC [ RunTime:0.012555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335117 ORDER BY `unit` DESC [ RunTime:0.036490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335117 LIMIT 2 [ RunTime:0.047692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335117 ORDER BY `minOrder` ASC [ RunTime:0.013543s ]
select * from pdf where partno='6030703' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030703' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023497s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335117 AND `partno` = '6030703' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190402 [ RunTime:0.016953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335116 LIMIT 5 [ RunTime:0.023753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335116 ORDER BY `minOrder` ASC [ RunTime:0.019742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335116 ORDER BY `unit` DESC [ RunTime:0.005788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335116 LIMIT 2 [ RunTime:0.025288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335116 ORDER BY `minOrder` ASC [ RunTime:0.014797s ]
select * from pdf where partno='6030702' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030702' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008250s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335116 AND `partno` = '6030702' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190401 [ RunTime:0.011201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335115 LIMIT 5 [ RunTime:0.005004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335115 ORDER BY `minOrder` ASC [ RunTime:0.005599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335115 ORDER BY `unit` DESC [ RunTime:0.025141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335115 LIMIT 2 [ RunTime:0.023873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335115 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
select * from pdf where partno='6030704' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030704' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008786s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335115 AND `partno` = '6030704' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200617 [ RunTime:0.009132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63009584 LIMIT 5 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63009584 ORDER BY `minOrder` ASC [ RunTime:0.015631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63009584 ORDER BY `unit` DESC [ RunTime:0.016928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63009584 LIMIT 2 [ RunTime:0.013511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63009584 ORDER BY `minOrder` ASC [ RunTime:0.007726s ]
select * from pdf where partno='6030795' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030795' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019615s ]
SELECT `id` FROM `stock` WHERE `id` <> 63009584 AND `partno` = '6030795' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494825 [ RunTime:0.002200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58200538 LIMIT 5 [ RunTime:0.003773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58200538 ORDER BY `minOrder` ASC [ RunTime:0.006465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58200538 ORDER BY `unit` DESC [ RunTime:0.003207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58200538 LIMIT 2 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58200538 ORDER BY `minOrder` ASC [ RunTime:0.009215s ]
select * from pdf where partno='60307R' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.011122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60307R' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.017412s ]
SELECT `id` FROM `stock` WHERE `id` <> 58200538 AND `partno` = '60307R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.009541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706903 [ RunTime:0.009660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63337135 LIMIT 5 [ RunTime:0.003688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337135 ORDER BY `minOrder` ASC [ RunTime:0.014584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63337135 ORDER BY `unit` DESC [ RunTime:0.035590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63337135 LIMIT 2 [ RunTime:0.014816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337135 ORDER BY `minOrder` ASC [ RunTime:0.007294s ]
select * from pdf where partno='6030722' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030722' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005079s ]
SELECT `id` FROM `stock` WHERE `id` <> 63337135 AND `partno` = '6030722' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784197 [ RunTime:0.029069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63337133 LIMIT 5 [ RunTime:0.011663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337133 ORDER BY `minOrder` ASC [ RunTime:0.005278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63337133 ORDER BY `unit` DESC [ RunTime:0.017376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63337133 LIMIT 2 [ RunTime:0.035855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63337133 ORDER BY `minOrder` ASC [ RunTime:0.009210s ]
select * from pdf where partno='6030721' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030721' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022468s ]
SELECT `id` FROM `stock` WHERE `id` <> 63337133 AND `partno` = '6030721' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784196 [ RunTime:0.016417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514304 LIMIT 5 [ RunTime:0.019704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514304 ORDER BY `minOrder` ASC [ RunTime:0.007010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514304 ORDER BY `unit` DESC [ RunTime:0.000782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514304 LIMIT 2 [ RunTime:0.010114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514304 ORDER BY `minOrder` ASC [ RunTime:0.001925s ]
select * from pdf where partno='60307' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60307' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.026762s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514304 AND `partno` = '60307' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.051540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524740 [ RunTime:0.009863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347417 LIMIT 5 [ RunTime:0.014899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347417 ORDER BY `minOrder` ASC [ RunTime:0.013621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347417 ORDER BY `unit` DESC [ RunTime:0.034910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347417 LIMIT 2 [ RunTime:0.034245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347417 ORDER BY `minOrder` ASC [ RunTime:0.020426s ]
select * from pdf where partno='6030717' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030717' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019031s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347417 AND `partno` = '6030717' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781513 [ RunTime:0.002790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347416 LIMIT 5 [ RunTime:0.042237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347416 ORDER BY `minOrder` ASC [ RunTime:0.044780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347416 ORDER BY `unit` DESC [ RunTime:0.006396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347416 LIMIT 2 [ RunTime:0.013500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347416 ORDER BY `minOrder` ASC [ RunTime:0.064432s ]
select * from pdf where partno='6030718' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030718' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.042990s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347416 AND `partno` = '6030718' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011739 [ RunTime:0.026741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347415 LIMIT 5 [ RunTime:0.021915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347415 ORDER BY `minOrder` ASC [ RunTime:0.005867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347415 ORDER BY `unit` DESC [ RunTime:0.008178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347415 LIMIT 2 [ RunTime:0.025474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347415 ORDER BY `minOrder` ASC [ RunTime:0.011476s ]
select * from pdf where partno='6030714' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030714' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014422s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347415 AND `partno` = '6030714' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781512 [ RunTime:0.007314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347414 LIMIT 5 [ RunTime:0.019005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347414 ORDER BY `minOrder` ASC [ RunTime:0.014558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347414 ORDER BY `unit` DESC [ RunTime:0.035356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347414 LIMIT 2 [ RunTime:0.007851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347414 ORDER BY `minOrder` ASC [ RunTime:0.004679s ]
select * from pdf where partno='6030719' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030719' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008104s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347414 AND `partno` = '6030719' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781511 [ RunTime:0.010926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346614 LIMIT 5 [ RunTime:0.002016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346614 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346614 ORDER BY `unit` DESC [ RunTime:0.011536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346614 LIMIT 2 [ RunTime:0.003679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346614 ORDER BY `minOrder` ASC [ RunTime:0.003680s ]
select * from pdf where partno='6030711' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030711' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039813s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346614 AND `partno` = '6030711' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781038 [ RunTime:0.002109s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017088s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020386s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019515s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023219s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005631s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006398s ]
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 '60307%' OR `brand` LIKE '60307%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008544s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60307%' OR `brand` LIKE '60307%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025239s ]