SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001548s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=SMAJ45C&search=1' [ RunTime:0.005994s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001176s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006401s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002899s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.008817s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002396s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002822s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001414s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ45C' LIMIT 1 [ RunTime:0.006970s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-22 12:22:26' WHERE `partno` = 'SMAJ45C' [ RunTime:0.006129s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003788s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044281s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801874 LIMIT 5 [ RunTime:0.028575s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801874 ORDER BY `minOrder` ASC [ RunTime:0.012558s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801874 ORDER BY `unit` DESC [ RunTime:0.009816s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801874 LIMIT 2 [ RunTime:0.026964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801874 ORDER BY `minOrder` ASC [ RunTime:0.014834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911930 LIMIT 5 [ RunTime:0.006721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911930 ORDER BY `minOrder` ASC [ RunTime:0.010814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911930 ORDER BY `unit` DESC [ RunTime:0.014124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911930 LIMIT 2 [ RunTime:0.011095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911930 ORDER BY `minOrder` ASC [ RunTime:0.006011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661534 LIMIT 5 [ RunTime:0.022769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661534 ORDER BY `minOrder` ASC [ RunTime:0.026986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661534 ORDER BY `unit` DESC [ RunTime:0.024489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661534 LIMIT 2 [ RunTime:0.037586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661534 ORDER BY `minOrder` ASC [ RunTime:0.033115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806550 LIMIT 5 [ RunTime:0.006766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806550 ORDER BY `minOrder` ASC [ RunTime:0.014600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806550 ORDER BY `unit` DESC [ RunTime:0.015508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806550 LIMIT 2 [ RunTime:0.008545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806550 ORDER BY `minOrder` ASC [ RunTime:0.012699s ]
select * from pdf where partno='SMAJ45CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.010571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813104 LIMIT 5 [ RunTime:0.019416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813104 ORDER BY `minOrder` ASC [ RunTime:0.016885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813104 ORDER BY `unit` DESC [ RunTime:0.013900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813104 LIMIT 2 [ RunTime:0.006681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813104 ORDER BY `minOrder` ASC [ RunTime:0.014440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905807 LIMIT 5 [ RunTime:0.053250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905807 ORDER BY `minOrder` ASC [ RunTime:0.030132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905807 ORDER BY `unit` DESC [ RunTime:0.017001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905807 LIMIT 2 [ RunTime:0.041005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905807 ORDER BY `minOrder` ASC [ RunTime:0.025251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676993 LIMIT 5 [ RunTime:0.013112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676993 ORDER BY `minOrder` ASC [ RunTime:0.030935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676993 ORDER BY `unit` DESC [ RunTime:0.017989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676993 LIMIT 2 [ RunTime:0.049598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676993 ORDER BY `minOrder` ASC [ RunTime:0.048306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828660 LIMIT 5 [ RunTime:0.030430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828660 ORDER BY `minOrder` ASC [ RunTime:0.012552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828660 ORDER BY `unit` DESC [ RunTime:0.012942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828660 LIMIT 2 [ RunTime:0.009723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828660 ORDER BY `minOrder` ASC [ RunTime:0.022853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663704 LIMIT 5 [ RunTime:0.026820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663704 ORDER BY `minOrder` ASC [ RunTime:0.045875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663704 ORDER BY `unit` DESC [ RunTime:0.020070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663704 LIMIT 2 [ RunTime:0.014832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663704 ORDER BY `minOrder` ASC [ RunTime:0.010915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824083 LIMIT 5 [ RunTime:0.012438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824083 ORDER BY `minOrder` ASC [ RunTime:0.015976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14824083 ORDER BY `unit` DESC [ RunTime:0.024686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14824083 LIMIT 2 [ RunTime:0.013588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824083 ORDER BY `minOrder` ASC [ RunTime:0.013618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906146 LIMIT 5 [ RunTime:0.043577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906146 ORDER BY `minOrder` ASC [ RunTime:0.064690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906146 ORDER BY `unit` DESC [ RunTime:0.055967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906146 LIMIT 2 [ RunTime:0.101920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906146 ORDER BY `minOrder` ASC [ RunTime:0.015235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801651 LIMIT 5 [ RunTime:0.056870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801651 ORDER BY `minOrder` ASC [ RunTime:0.019516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801651 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801651 LIMIT 2 [ RunTime:0.020282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801651 ORDER BY `minOrder` ASC [ RunTime:0.050253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802943 LIMIT 5 [ RunTime:0.045042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802943 ORDER BY `minOrder` ASC [ RunTime:0.021489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802943 ORDER BY `unit` DESC [ RunTime:0.023101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802943 LIMIT 2 [ RunTime:0.012696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802943 ORDER BY `minOrder` ASC [ RunTime:0.019985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691418 LIMIT 5 [ RunTime:0.006679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691418 ORDER BY `minOrder` ASC [ RunTime:0.027426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691418 ORDER BY `unit` DESC [ RunTime:0.029772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691418 LIMIT 2 [ RunTime:0.005664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691418 ORDER BY `minOrder` ASC [ RunTime:0.028586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691417 LIMIT 5 [ RunTime:0.011950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691417 ORDER BY `minOrder` ASC [ RunTime:0.010420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691417 ORDER BY `unit` DESC [ RunTime:0.016597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691417 LIMIT 2 [ RunTime:0.011451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691417 ORDER BY `minOrder` ASC [ RunTime:0.035630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687426 LIMIT 5 [ RunTime:0.059528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687426 ORDER BY `minOrder` ASC [ RunTime:0.050054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687426 ORDER BY `unit` DESC [ RunTime:0.044469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687426 LIMIT 2 [ RunTime:0.093803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687426 ORDER BY `minOrder` ASC [ RunTime:0.043418s ]
select * from pdf where partno='SMAJ45C' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.044581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677874 LIMIT 5 [ RunTime:0.047516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677874 ORDER BY `minOrder` ASC [ RunTime:0.038625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677874 ORDER BY `unit` DESC [ RunTime:0.050490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677874 LIMIT 2 [ RunTime:0.038360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677874 ORDER BY `minOrder` ASC [ RunTime:0.020479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673967 LIMIT 5 [ RunTime:0.016276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673967 ORDER BY `minOrder` ASC [ RunTime:0.022269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673967 ORDER BY `unit` DESC [ RunTime:0.041456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673967 LIMIT 2 [ RunTime:0.021211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673967 ORDER BY `minOrder` ASC [ RunTime:0.040283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672319 LIMIT 5 [ RunTime:0.119764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672319 ORDER BY `minOrder` ASC [ RunTime:0.029630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672319 ORDER BY `unit` DESC [ RunTime:0.052018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672319 LIMIT 2 [ RunTime:0.063537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672319 ORDER BY `minOrder` ASC [ RunTime:0.060276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672318 LIMIT 5 [ RunTime:0.018017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672318 ORDER BY `minOrder` ASC [ RunTime:0.024258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672318 ORDER BY `unit` DESC [ RunTime:0.025559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672318 LIMIT 2 [ RunTime:0.027241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672318 ORDER BY `minOrder` ASC [ RunTime:0.027263s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071702s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160997 LIMIT 5 [ RunTime:0.018156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160997 ORDER BY `minOrder` ASC [ RunTime:0.010362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160997 ORDER BY `unit` DESC [ RunTime:0.051949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160997 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160997 ORDER BY `minOrder` ASC [ RunTime:0.010871s ]
select * from pdf where partno='SMAJ45CA' and brandshort='MDD' limit 1 [ RunTime:0.010688s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.006042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101443 LIMIT 5 [ RunTime:0.002222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101443 ORDER BY `minOrder` ASC [ RunTime:0.005244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101443 ORDER BY `unit` DESC [ RunTime:0.006395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101443 LIMIT 2 [ RunTime:0.015273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101443 ORDER BY `minOrder` ASC [ RunTime:0.002823s ]
select * from pdf where partno='SMAJ45CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.006675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.008359s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101443 AND `partno` = 'SMAJ45CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.012280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911930 [ RunTime:0.013515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42100600 LIMIT 5 [ RunTime:0.022160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100600 ORDER BY `minOrder` ASC [ RunTime:0.001289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42100600 ORDER BY `unit` DESC [ RunTime:0.010677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42100600 LIMIT 2 [ RunTime:0.001645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100600 ORDER BY `minOrder` ASC [ RunTime:0.010175s ]
select * from pdf where partno='SMAJ45CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.004375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.003504s ]
SELECT `id` FROM `stock` WHERE `id` <> 42100600 AND `partno` = 'SMAJ45CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.024059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661534 [ RunTime:0.010290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112625 LIMIT 5 [ RunTime:0.003275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112625 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112625 ORDER BY `unit` DESC [ RunTime:0.002609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112625 LIMIT 2 [ RunTime:0.009374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112625 ORDER BY `minOrder` ASC [ RunTime:0.016982s ]
select * from pdf where partno='SMAJ45CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003244s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112625 AND `partno` = 'SMAJ45CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813104 [ RunTime:0.006676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42151444 LIMIT 5 [ RunTime:0.013225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151444 ORDER BY `minOrder` ASC [ RunTime:0.001095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42151444 ORDER BY `unit` DESC [ RunTime:0.018719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42151444 LIMIT 2 [ RunTime:0.013685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151444 ORDER BY `minOrder` ASC [ RunTime:0.009234s ]
select * from pdf where partno='SMAJ45CAH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.003774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CAH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.005799s ]
SELECT `id` FROM `stock` WHERE `id` <> 42151444 AND `partno` = 'SMAJ45CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.014446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828660 [ RunTime:0.022993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162548 LIMIT 5 [ RunTime:0.017053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162548 ORDER BY `minOrder` ASC [ RunTime:0.001185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162548 ORDER BY `unit` DESC [ RunTime:0.012395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162548 LIMIT 2 [ RunTime:0.026958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162548 ORDER BY `minOrder` ASC [ RunTime:0.003157s ]
select * from pdf where partno='SMAJ45CA-A' and brandshort='Yenyo Technology' limit 1 [ RunTime:0.015255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA-A' OR `brand` LIKE 'Yenyo Technology%' ) ) LIMIT 1 [ RunTime:0.019092s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162548 AND `partno` = 'SMAJ45CA-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%yenyo technology%' ) [ RunTime:0.010574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663704 [ RunTime:0.007937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42154889 LIMIT 5 [ RunTime:0.017905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154889 ORDER BY `minOrder` ASC [ RunTime:0.050172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42154889 ORDER BY `unit` DESC [ RunTime:0.037844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42154889 LIMIT 2 [ RunTime:0.010421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154889 ORDER BY `minOrder` ASC [ RunTime:0.022849s ]
select * from pdf where partno='SMAJ45CHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.037031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.015137s ]
SELECT `id` FROM `stock` WHERE `id` <> 42154889 AND `partno` = 'SMAJ45CHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.034391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906146 [ RunTime:0.016026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42145758 LIMIT 5 [ RunTime:0.044537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145758 ORDER BY `minOrder` ASC [ RunTime:0.004998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42145758 ORDER BY `unit` DESC [ RunTime:0.015278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42145758 LIMIT 2 [ RunTime:0.003730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145758 ORDER BY `minOrder` ASC [ RunTime:0.008154s ]
select * from pdf where partno='SMAJ45CA' and brandshort='Lumimax Optoelectronic Technology' limit 1 [ RunTime:0.025335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA' OR `brand` LIKE 'Lumimax Optoelectronic Technology%' ) ) LIMIT 1 [ RunTime:0.015751s ]
SELECT `id` FROM `stock` WHERE `id` <> 42145758 AND `partno` = 'SMAJ45CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumimax optoelectronic technology%' ) [ RunTime:0.010310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801651 [ RunTime:0.012167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114313 LIMIT 5 [ RunTime:0.021922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114313 ORDER BY `minOrder` ASC [ RunTime:0.045342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114313 ORDER BY `unit` DESC [ RunTime:0.014151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114313 LIMIT 2 [ RunTime:0.020999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114313 ORDER BY `minOrder` ASC [ RunTime:0.022767s ]
select * from pdf where partno='SMAJ45CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.012158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.016518s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114313 AND `partno` = 'SMAJ45CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.027344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676993 [ RunTime:0.052280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42124438 LIMIT 5 [ RunTime:0.000213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124438 ORDER BY `minOrder` ASC [ RunTime:0.013344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42124438 ORDER BY `unit` DESC [ RunTime:0.034041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42124438 LIMIT 2 [ RunTime:0.019060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124438 ORDER BY `minOrder` ASC [ RunTime:0.019833s ]
select * from pdf where partno='SMAJ45CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.014239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.050954s ]
SELECT `id` FROM `stock` WHERE `id` <> 42124438 AND `partno` = 'SMAJ45CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.054322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824083 [ RunTime:0.009037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169738 LIMIT 5 [ RunTime:0.034327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169738 ORDER BY `minOrder` ASC [ RunTime:0.021228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169738 ORDER BY `unit` DESC [ RunTime:0.019818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169738 LIMIT 2 [ RunTime:0.042569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169738 ORDER BY `minOrder` ASC [ RunTime:0.016900s ]
select * from pdf where partno='SMAJ45CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.020518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.045360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267613 LIMIT 5 [ RunTime:0.013438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267613 ORDER BY `minOrder` ASC [ RunTime:0.060872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267613 ORDER BY `unit` DESC [ RunTime:0.014653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267613 LIMIT 2 [ RunTime:0.005106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267613 ORDER BY `minOrder` ASC [ RunTime:0.018592s ]
select * from pdf where partno='SMAJ45CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.030409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.006503s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267613 AND `partno` = 'SMAJ45CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.019555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918045 [ RunTime:0.011914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256223 LIMIT 5 [ RunTime:0.023865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256223 ORDER BY `minOrder` ASC [ RunTime:0.021384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256223 ORDER BY `unit` DESC [ RunTime:0.044975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256223 LIMIT 2 [ RunTime:0.017751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256223 ORDER BY `minOrder` ASC [ RunTime:0.024692s ]
select * from pdf where partno='SMAJ45CA-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.019995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002132s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256223 AND `partno` = 'SMAJ45CA-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.003229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673967 [ RunTime:0.002412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42244439 LIMIT 5 [ RunTime:0.012668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244439 ORDER BY `minOrder` ASC [ RunTime:0.055016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42244439 ORDER BY `unit` DESC [ RunTime:0.013664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42244439 LIMIT 2 [ RunTime:0.018295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244439 ORDER BY `minOrder` ASC [ RunTime:0.003881s ]
select * from pdf where partno='SMAJ45CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.019761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.013772s ]
SELECT `id` FROM `stock` WHERE `id` <> 42244439 AND `partno` = 'SMAJ45CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.025703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672319 [ RunTime:0.012098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42244438 LIMIT 5 [ RunTime:0.026705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244438 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42244438 ORDER BY `unit` DESC [ RunTime:0.014363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42244438 LIMIT 2 [ RunTime:0.015014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244438 ORDER BY `minOrder` ASC [ RunTime:0.010380s ]
select * from pdf where partno='SMAJ45CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.004887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.016750s ]
SELECT `id` FROM `stock` WHERE `id` <> 42244438 AND `partno` = 'SMAJ45CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.026894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672318 [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42232946 LIMIT 5 [ RunTime:0.005430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232946 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42232946 ORDER BY `unit` DESC [ RunTime:0.011747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42232946 LIMIT 2 [ RunTime:0.009559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232946 ORDER BY `minOrder` ASC [ RunTime:0.025191s ]
select * from pdf where partno='SMAJ45CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.053134s ]
SELECT `id` FROM `stock` WHERE `id` <> 42232946 AND `partno` = 'SMAJ45CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.017864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670627 [ RunTime:0.007855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228951 LIMIT 5 [ RunTime:0.014716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228951 ORDER BY `minOrder` ASC [ RunTime:0.029600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228951 ORDER BY `unit` DESC [ RunTime:0.012319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228951 LIMIT 2 [ RunTime:0.028563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228951 ORDER BY `minOrder` ASC [ RunTime:0.021512s ]
select * from pdf where partno='SMAJ45CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001090s ]
SELECT `id` FROM `stock` WHERE `id` <> 42228951 AND `partno` = 'SMAJ45CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669516 [ RunTime:0.021123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42226836 LIMIT 5 [ RunTime:0.009701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226836 ORDER BY `minOrder` ASC [ RunTime:0.024781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42226836 ORDER BY `unit` DESC [ RunTime:0.005327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42226836 LIMIT 2 [ RunTime:0.003133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226836 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
select * from pdf where partno='SMAJ45CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001710s ]
SELECT `id` FROM `stock` WHERE `id` <> 42226836 AND `partno` = 'SMAJ45CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.008426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670441 [ RunTime:0.004104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42220233 LIMIT 5 [ RunTime:0.028521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220233 ORDER BY `minOrder` ASC [ RunTime:0.031898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42220233 ORDER BY `unit` DESC [ RunTime:0.004981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42220233 LIMIT 2 [ RunTime:0.012063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220233 ORDER BY `minOrder` ASC [ RunTime:0.015546s ]
select * from pdf where partno='SMAJ45CAHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CAHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014364s ]
SELECT `id` FROM `stock` WHERE `id` <> 42220233 AND `partno` = 'SMAJ45CAHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913607 [ RunTime:0.014614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42214598 LIMIT 5 [ RunTime:0.018030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214598 ORDER BY `minOrder` ASC [ RunTime:0.017632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42214598 ORDER BY `unit` DESC [ RunTime:0.000494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42214598 LIMIT 2 [ RunTime:0.031446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214598 ORDER BY `minOrder` ASC [ RunTime:0.011704s ]
select * from pdf where partno='SMAJ45CA-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.020220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ45CA-M3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013146s ]
SELECT `id` FROM `stock` WHERE `id` <> 42214598 AND `partno` = 'SMAJ45CA-M3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809490 [ RunTime:0.023914s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065622s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032260s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028611s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028840s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045182s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046652s ]
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 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052129s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ45C%' OR `brand` LIKE 'SMAJ45C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041559s ]