SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002837s ]
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=SMAJ120&search=1' [ RunTime:0.007169s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000995s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000508s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001940s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.007401s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002099s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013828s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001499s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ120' LIMIT 1 [ RunTime:0.000788s ]
UPDATE `stock_search` SET `count` = 13 , `updatetime` = '2026-08-17 22:11:57' WHERE `partno` = 'SMAJ120' [ RunTime:0.012695s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001716s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063815s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.050556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906713 LIMIT 5 [ RunTime:0.020430s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906713 ORDER BY `minOrder` ASC [ RunTime:0.030678s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906713 ORDER BY `unit` DESC [ RunTime:0.027340s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906713 LIMIT 2 [ RunTime:0.046964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906713 ORDER BY `minOrder` ASC [ RunTime:0.023871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799929 LIMIT 5 [ RunTime:0.034082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799929 ORDER BY `minOrder` ASC [ RunTime:0.047509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799929 ORDER BY `unit` DESC [ RunTime:0.043026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799929 LIMIT 2 [ RunTime:0.046211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799929 ORDER BY `minOrder` ASC [ RunTime:0.032985s ]
select * from pdf where partno='SMAJ120A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.074452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814341 LIMIT 5 [ RunTime:0.046393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814341 ORDER BY `minOrder` ASC [ RunTime:0.028681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814341 ORDER BY `unit` DESC [ RunTime:0.057064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814341 LIMIT 2 [ RunTime:0.015881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814341 ORDER BY `minOrder` ASC [ RunTime:0.031391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926470 LIMIT 5 [ RunTime:0.060775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926470 ORDER BY `minOrder` ASC [ RunTime:0.056058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13926470 ORDER BY `unit` DESC [ RunTime:0.044133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13926470 LIMIT 2 [ RunTime:0.032057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926470 ORDER BY `minOrder` ASC [ RunTime:0.012955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664813 LIMIT 5 [ RunTime:0.043243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664813 ORDER BY `minOrder` ASC [ RunTime:0.044494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664813 ORDER BY `unit` DESC [ RunTime:0.032534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664813 LIMIT 2 [ RunTime:0.022879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664813 ORDER BY `minOrder` ASC [ RunTime:0.013510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665040 LIMIT 5 [ RunTime:0.025790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665040 ORDER BY `minOrder` ASC [ RunTime:0.011810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665040 ORDER BY `unit` DESC [ RunTime:0.020363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665040 LIMIT 2 [ RunTime:0.014037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665040 ORDER BY `minOrder` ASC [ RunTime:0.007979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801987 LIMIT 5 [ RunTime:0.004205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801987 ORDER BY `minOrder` ASC [ RunTime:0.020372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801987 ORDER BY `unit` DESC [ RunTime:0.035536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801987 LIMIT 2 [ RunTime:0.029720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801987 ORDER BY `minOrder` ASC [ RunTime:0.004709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919269 LIMIT 5 [ RunTime:0.017750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919269 ORDER BY `minOrder` ASC [ RunTime:0.022437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919269 ORDER BY `unit` DESC [ RunTime:0.011444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919269 LIMIT 2 [ RunTime:0.009091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919269 ORDER BY `minOrder` ASC [ RunTime:0.005494s ]
select * from pdf where partno='SMAJ120CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.006914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906755 LIMIT 5 [ RunTime:0.004100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906755 ORDER BY `minOrder` ASC [ RunTime:0.018741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906755 ORDER BY `unit` DESC [ RunTime:0.011385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906755 LIMIT 2 [ RunTime:0.016550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906755 ORDER BY `minOrder` ASC [ RunTime:0.001295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904744 LIMIT 5 [ RunTime:0.013134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904744 ORDER BY `minOrder` ASC [ RunTime:0.016234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904744 ORDER BY `unit` DESC [ RunTime:0.018506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904744 LIMIT 2 [ RunTime:0.011579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904744 ORDER BY `minOrder` ASC [ RunTime:0.003880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661333 LIMIT 5 [ RunTime:0.011394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661333 ORDER BY `minOrder` ASC [ RunTime:0.001004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661333 ORDER BY `unit` DESC [ RunTime:0.007142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661333 LIMIT 2 [ RunTime:0.011272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661333 ORDER BY `minOrder` ASC [ RunTime:0.003503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13929551 LIMIT 5 [ RunTime:0.014170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929551 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13929551 ORDER BY `unit` DESC [ RunTime:0.020263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13929551 LIMIT 2 [ RunTime:0.006324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929551 ORDER BY `minOrder` ASC [ RunTime:0.005373s ]
select * from pdf where partno='SMAJ120A-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801138 LIMIT 5 [ RunTime:0.010304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801138 ORDER BY `minOrder` ASC [ RunTime:0.009984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801138 ORDER BY `unit` DESC [ RunTime:0.003067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801138 LIMIT 2 [ RunTime:0.018698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801138 ORDER BY `minOrder` ASC [ RunTime:0.005951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906144 LIMIT 5 [ RunTime:0.033308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906144 ORDER BY `minOrder` ASC [ RunTime:0.007485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906144 ORDER BY `unit` DESC [ RunTime:0.007088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906144 LIMIT 2 [ RunTime:0.018646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906144 ORDER BY `minOrder` ASC [ RunTime:0.018746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663346 LIMIT 5 [ RunTime:0.021321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663346 ORDER BY `minOrder` ASC [ RunTime:0.014558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663346 ORDER BY `unit` DESC [ RunTime:0.003611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663346 LIMIT 2 [ RunTime:0.001475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663346 ORDER BY `minOrder` ASC [ RunTime:0.004233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906149 LIMIT 5 [ RunTime:0.009609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906149 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906149 ORDER BY `unit` DESC [ RunTime:0.024736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906149 LIMIT 2 [ RunTime:0.012379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906149 ORDER BY `minOrder` ASC [ RunTime:0.014907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662846 LIMIT 5 [ RunTime:0.003887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662846 ORDER BY `minOrder` ASC [ RunTime:0.012628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662846 ORDER BY `unit` DESC [ RunTime:0.014538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662846 LIMIT 2 [ RunTime:0.011278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662846 ORDER BY `minOrder` ASC [ RunTime:0.000979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825961 LIMIT 5 [ RunTime:0.006623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825961 ORDER BY `minOrder` ASC [ RunTime:0.011059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825961 ORDER BY `unit` DESC [ RunTime:0.011313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825961 LIMIT 2 [ RunTime:0.014665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825961 ORDER BY `minOrder` ASC [ RunTime:0.025609s ]
select * from pdf where partno='SMAJ120CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825207 LIMIT 5 [ RunTime:0.003725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825207 ORDER BY `minOrder` ASC [ RunTime:0.007935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825207 ORDER BY `unit` DESC [ RunTime:0.003775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825207 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825207 ORDER BY `minOrder` ASC [ RunTime:0.007119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907433 LIMIT 5 [ RunTime:0.010979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907433 ORDER BY `minOrder` ASC [ RunTime:0.030019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907433 ORDER BY `unit` DESC [ RunTime:0.010608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907433 LIMIT 2 [ RunTime:0.008955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907433 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141513 LIMIT 5 [ RunTime:0.004372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141513 ORDER BY `minOrder` ASC [ RunTime:0.014475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141513 ORDER BY `unit` DESC [ RunTime:0.021284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141513 LIMIT 2 [ RunTime:0.015141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141513 ORDER BY `minOrder` ASC [ RunTime:0.005519s ]
select * from pdf where partno='smaj120a' and brandshort='littelfuse' limit 1 [ RunTime:0.009288s ]
select foldpath,foldpath2,filename from pdf_file where id=341581 limit 1 [ RunTime:0.003244s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.000906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smaj120a' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.020683s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42161562 LIMIT 5 [ RunTime:0.010038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161562 ORDER BY `minOrder` ASC [ RunTime:0.015766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42161562 ORDER BY `unit` DESC [ RunTime:0.003893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42161562 LIMIT 2 [ RunTime:0.008940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161562 ORDER BY `minOrder` ASC [ RunTime:0.013483s ]
select * from pdf where partno='SMAJ120A' and brandshort='MDD' limit 1 [ RunTime:0.008430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.004933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123934 LIMIT 5 [ RunTime:0.011347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123934 ORDER BY `minOrder` ASC [ RunTime:0.003905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123934 ORDER BY `unit` DESC [ RunTime:0.008718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123934 LIMIT 2 [ RunTime:0.021517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123934 ORDER BY `minOrder` ASC [ RunTime:0.010946s ]
select * from pdf where partno='SMAJ120A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.023957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099793 LIMIT 5 [ RunTime:0.018121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099793 ORDER BY `minOrder` ASC [ RunTime:0.035420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099793 ORDER BY `unit` DESC [ RunTime:0.009586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099793 LIMIT 2 [ RunTime:0.003118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099793 ORDER BY `minOrder` ASC [ RunTime:0.020172s ]
select * from pdf where partno='SMAJ120A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.019630s ]
SELECT `id` FROM `stock` WHERE `id` <> 42099793 AND `partno` = 'SMAJ120A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.029578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799929 [ RunTime:0.014495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113001 LIMIT 5 [ RunTime:0.016607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113001 ORDER BY `minOrder` ASC [ RunTime:0.016153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113001 ORDER BY `unit` DESC [ RunTime:0.007901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113001 LIMIT 2 [ RunTime:0.019060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113001 ORDER BY `minOrder` ASC [ RunTime:0.000806s ]
select * from pdf where partno='SMAJ120CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.028026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004845s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113001 AND `partno` = 'SMAJ120CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.003225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664813 [ RunTime:0.009060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42102015 LIMIT 5 [ RunTime:0.024812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102015 ORDER BY `minOrder` ASC [ RunTime:0.015651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42102015 ORDER BY `unit` DESC [ RunTime:0.004742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42102015 LIMIT 2 [ RunTime:0.016089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102015 ORDER BY `minOrder` ASC [ RunTime:0.004928s ]
select * from pdf where partno='SMAJ120CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.026263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.009499s ]
SELECT `id` FROM `stock` WHERE `id` <> 42102015 AND `partno` = 'SMAJ120CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.016882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665040 [ RunTime:0.003618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162546 LIMIT 5 [ RunTime:0.022450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162546 ORDER BY `minOrder` ASC [ RunTime:0.014600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162546 ORDER BY `unit` DESC [ RunTime:0.008125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162546 LIMIT 2 [ RunTime:0.010753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162546 ORDER BY `minOrder` ASC [ RunTime:0.018614s ]
select * from pdf where partno='SMAJ120A-A' and brandshort='Yenyo Technology' limit 1 [ RunTime:0.018785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A-A' OR `brand` LIKE 'Yenyo Technology%' ) ) LIMIT 1 [ RunTime:0.020749s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162546 AND `partno` = 'SMAJ120A-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%yenyo technology%' ) [ RunTime:0.032443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906755 [ RunTime:0.015517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152973 LIMIT 5 [ RunTime:0.023346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152973 ORDER BY `minOrder` ASC [ RunTime:0.034582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152973 ORDER BY `unit` DESC [ RunTime:0.029724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152973 LIMIT 2 [ RunTime:0.022809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152973 ORDER BY `minOrder` ASC [ RunTime:0.011029s ]
select * from pdf where partno='SMAJ120A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.036343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.020329s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152973 AND `partno` = 'SMAJ120A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.012772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661333 [ RunTime:0.039175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112393 LIMIT 5 [ RunTime:0.025377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112393 ORDER BY `minOrder` ASC [ RunTime:0.037048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112393 ORDER BY `unit` DESC [ RunTime:0.017182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112393 LIMIT 2 [ RunTime:0.015908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112393 ORDER BY `minOrder` ASC [ RunTime:0.014020s ]
select * from pdf where partno='SMAJ120A-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.018720s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112393 AND `partno` = 'SMAJ120A-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13929551 [ RunTime:0.017454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153406 LIMIT 5 [ RunTime:0.013533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153406 ORDER BY `minOrder` ASC [ RunTime:0.017134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153406 ORDER BY `unit` DESC [ RunTime:0.018132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153406 LIMIT 2 [ RunTime:0.015840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153406 ORDER BY `minOrder` ASC [ RunTime:0.013333s ]
select * from pdf where partno='SMAJ120HR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.018245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120HR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.026808s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153406 AND `partno` = 'SMAJ120HR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.041918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801138 [ RunTime:0.023128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42154885 LIMIT 5 [ RunTime:0.031014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154885 ORDER BY `minOrder` ASC [ RunTime:0.013723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42154885 ORDER BY `unit` DESC [ RunTime:0.044227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42154885 LIMIT 2 [ RunTime:0.033368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154885 ORDER BY `minOrder` ASC [ RunTime:0.014989s ]
select * from pdf where partno='SMAJ120CAHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.012763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.029308s ]
SELECT `id` FROM `stock` WHERE `id` <> 42154885 AND `partno` = 'SMAJ120CAHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.024353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906144 [ RunTime:0.028218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159156 LIMIT 5 [ RunTime:0.028119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159156 ORDER BY `minOrder` ASC [ RunTime:0.041658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159156 ORDER BY `unit` DESC [ RunTime:0.018290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159156 LIMIT 2 [ RunTime:0.004189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159156 ORDER BY `minOrder` ASC [ RunTime:0.016890s ]
select * from pdf where partno='SMAJ120A' and brandshort='Lumimax Optoelectronic Technology' limit 1 [ RunTime:0.009571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A' OR `brand` LIKE 'Lumimax Optoelectronic Technology%' ) ) LIMIT 1 [ RunTime:0.006120s ]
SELECT `id` FROM `stock` WHERE `id` <> 42159156 AND `partno` = 'SMAJ120A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumimax optoelectronic technology%' ) [ RunTime:0.013437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663346 [ RunTime:0.015367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42154896 LIMIT 5 [ RunTime:0.034564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154896 ORDER BY `minOrder` ASC [ RunTime:0.030551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42154896 ORDER BY `unit` DESC [ RunTime:0.044452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42154896 LIMIT 2 [ RunTime:0.034988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154896 ORDER BY `minOrder` ASC [ RunTime:0.008664s ]
select * from pdf where partno='SMAJ120CHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.022809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.028340s ]
SELECT `id` FROM `stock` WHERE `id` <> 42154896 AND `partno` = 'SMAJ120CHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.037164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906149 [ RunTime:0.020733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153845 LIMIT 5 [ RunTime:0.036265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153845 ORDER BY `minOrder` ASC [ RunTime:0.042194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153845 ORDER BY `unit` DESC [ RunTime:0.034940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153845 LIMIT 2 [ RunTime:0.035428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153845 ORDER BY `minOrder` ASC [ RunTime:0.022766s ]
select * from pdf where partno='SMAJ120AHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.018067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.061658s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153845 AND `partno` = 'SMAJ120AHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.028207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662846 [ RunTime:0.034436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127070 LIMIT 5 [ RunTime:0.053427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127070 ORDER BY `minOrder` ASC [ RunTime:0.034559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127070 ORDER BY `unit` DESC [ RunTime:0.026963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127070 LIMIT 2 [ RunTime:0.057305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127070 ORDER BY `minOrder` ASC [ RunTime:0.012113s ]
select * from pdf where partno='SMAJ120CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019203s ]
SELECT `id` FROM `stock` WHERE `id` <> 42127070 AND `partno` = 'SMAJ120CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.026483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825961 [ RunTime:0.076829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112337 LIMIT 5 [ RunTime:0.060081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112337 ORDER BY `minOrder` ASC [ RunTime:0.010592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112337 ORDER BY `unit` DESC [ RunTime:0.023563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112337 LIMIT 2 [ RunTime:0.041638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112337 ORDER BY `minOrder` ASC [ RunTime:0.046783s ]
select * from pdf where partno='SMAJ120CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.041118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.032289s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112337 AND `partno` = 'SMAJ120CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.040691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919269 [ RunTime:0.057112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169719 LIMIT 5 [ RunTime:0.053794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169719 ORDER BY `minOrder` ASC [ RunTime:0.045316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169719 ORDER BY `unit` DESC [ RunTime:0.022304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169719 LIMIT 2 [ RunTime:0.041568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169719 ORDER BY `minOrder` ASC [ RunTime:0.009032s ]
select * from pdf where partno='SMAJ120A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.042139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.026666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169741 LIMIT 5 [ RunTime:0.035090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169741 ORDER BY `minOrder` ASC [ RunTime:0.065104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169741 ORDER BY `unit` DESC [ RunTime:0.018082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169741 LIMIT 2 [ RunTime:0.032211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169741 ORDER BY `minOrder` ASC [ RunTime:0.011031s ]
select * from pdf where partno='SMAJ120A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.033441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.020864s ]
SELECT `id` FROM `stock` WHERE `id` <> 42169741 AND `partno` = 'SMAJ120A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.076498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825207 [ RunTime:0.028757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168585 LIMIT 5 [ RunTime:0.049365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168585 ORDER BY `minOrder` ASC [ RunTime:0.053994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168585 ORDER BY `unit` DESC [ RunTime:0.052435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168585 LIMIT 2 [ RunTime:0.064715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168585 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
select * from pdf where partno='SMAJ120A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.057972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.053607s ]
SELECT `id` FROM `stock` WHERE `id` <> 42168585 AND `partno` = 'SMAJ120A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.074077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803278 [ RunTime:0.021770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42167848 LIMIT 5 [ RunTime:0.055938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167848 ORDER BY `minOrder` ASC [ RunTime:0.043777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42167848 ORDER BY `unit` DESC [ RunTime:0.062182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42167848 LIMIT 2 [ RunTime:0.053231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167848 ORDER BY `minOrder` ASC [ RunTime:0.014054s ]
select * from pdf where partno='SMAJ120A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.058474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.053061s ]
SELECT `id` FROM `stock` WHERE `id` <> 42167848 AND `partno` = 'SMAJ120A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.038386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814341 [ RunTime:0.008520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42293840 LIMIT 5 [ RunTime:0.053619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42293840 ORDER BY `minOrder` ASC [ RunTime:0.057519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42293840 ORDER BY `unit` DESC [ RunTime:0.058275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42293840 LIMIT 2 [ RunTime:0.062432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42293840 ORDER BY `minOrder` ASC [ RunTime:0.026415s ]
select * from pdf where partno='SMAJ120A-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.073343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120A-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.115205s ]
SELECT `id` FROM `stock` WHERE `id` <> 42293840 AND `partno` = 'SMAJ120A-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.035638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920806 [ RunTime:0.072603s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.105606s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075260s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039711s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030541s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016046s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026794s ]
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 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047158s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ120%' OR `brand` LIKE 'SMAJ120%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023818s ]