SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001764s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.162' , `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=1.5SMC11A&search=1' [ RunTime:0.013017s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002214s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016982s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001302s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.162' ) [ RunTime:0.012820s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003841s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008408s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001838s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5SMC11A' LIMIT 1 [ RunTime:0.010136s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-18 18:26:57' WHERE `partno` = '1.5SMC11A' [ RunTime:0.002131s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001751s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018129s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803144 LIMIT 5 [ RunTime:0.016109s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803144 ORDER BY `minOrder` ASC [ RunTime:0.022320s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803144 ORDER BY `unit` DESC [ RunTime:0.019318s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803144 LIMIT 2 [ RunTime:0.011074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803144 ORDER BY `minOrder` ASC [ RunTime:0.014179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692012 LIMIT 5 [ RunTime:0.007323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692012 ORDER BY `minOrder` ASC [ RunTime:0.018106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692012 ORDER BY `unit` DESC [ RunTime:0.000941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692012 LIMIT 2 [ RunTime:0.009567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692012 ORDER BY `minOrder` ASC [ RunTime:0.011660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692011 LIMIT 5 [ RunTime:0.013836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692011 ORDER BY `minOrder` ASC [ RunTime:0.007147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692011 ORDER BY `unit` DESC [ RunTime:0.017211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692011 LIMIT 2 [ RunTime:0.014108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692011 ORDER BY `minOrder` ASC [ RunTime:0.019918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688534 LIMIT 5 [ RunTime:0.024114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688534 ORDER BY `minOrder` ASC [ RunTime:0.007316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688534 ORDER BY `unit` DESC [ RunTime:0.012382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688534 LIMIT 2 [ RunTime:0.009980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688534 ORDER BY `minOrder` ASC [ RunTime:0.014912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678748 LIMIT 5 [ RunTime:0.029277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678748 ORDER BY `minOrder` ASC [ RunTime:0.009337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678748 ORDER BY `unit` DESC [ RunTime:0.016588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678748 LIMIT 2 [ RunTime:0.012211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678748 ORDER BY `minOrder` ASC [ RunTime:0.006760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674683 LIMIT 5 [ RunTime:0.018065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674683 ORDER BY `minOrder` ASC [ RunTime:0.019789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674683 ORDER BY `unit` DESC [ RunTime:0.044602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674683 LIMIT 2 [ RunTime:0.012415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674683 ORDER BY `minOrder` ASC [ RunTime:0.009627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674611 LIMIT 5 [ RunTime:0.004726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674611 ORDER BY `minOrder` ASC [ RunTime:0.007804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674611 ORDER BY `unit` DESC [ RunTime:0.019960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674611 LIMIT 2 [ RunTime:0.007847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674611 ORDER BY `minOrder` ASC [ RunTime:0.017010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673558 LIMIT 5 [ RunTime:0.019063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673558 ORDER BY `minOrder` ASC [ RunTime:0.020088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673558 ORDER BY `unit` DESC [ RunTime:0.013773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673558 LIMIT 2 [ RunTime:0.027679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673558 ORDER BY `minOrder` ASC [ RunTime:0.026530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671990 LIMIT 5 [ RunTime:0.017195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671990 ORDER BY `minOrder` ASC [ RunTime:0.012850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671990 ORDER BY `unit` DESC [ RunTime:0.013031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671990 LIMIT 2 [ RunTime:0.028356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671990 ORDER BY `minOrder` ASC [ RunTime:0.007735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670259 LIMIT 5 [ RunTime:0.010811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670259 ORDER BY `minOrder` ASC [ RunTime:0.016695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670259 ORDER BY `unit` DESC [ RunTime:0.007106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670259 LIMIT 2 [ RunTime:0.013783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670259 ORDER BY `minOrder` ASC [ RunTime:0.002335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829490 LIMIT 5 [ RunTime:0.024522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829490 ORDER BY `minOrder` ASC [ RunTime:0.037268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829490 ORDER BY `unit` DESC [ RunTime:0.005951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829490 LIMIT 2 [ RunTime:0.030680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829490 ORDER BY `minOrder` ASC [ RunTime:0.014989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815284 LIMIT 5 [ RunTime:0.029808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815284 ORDER BY `minOrder` ASC [ RunTime:0.014552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815284 ORDER BY `unit` DESC [ RunTime:0.028057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815284 LIMIT 2 [ RunTime:0.003090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815284 ORDER BY `minOrder` ASC [ RunTime:0.013829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814118 LIMIT 5 [ RunTime:0.013641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814118 ORDER BY `minOrder` ASC [ RunTime:0.018495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814118 ORDER BY `unit` DESC [ RunTime:0.016190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814118 LIMIT 2 [ RunTime:0.017806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814118 ORDER BY `minOrder` ASC [ RunTime:0.012462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814047 LIMIT 5 [ RunTime:0.056949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814047 ORDER BY `minOrder` ASC [ RunTime:0.041752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814047 ORDER BY `unit` DESC [ RunTime:0.034498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814047 LIMIT 2 [ RunTime:0.006443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814047 ORDER BY `minOrder` ASC [ RunTime:0.027142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814031 LIMIT 5 [ RunTime:0.050173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814031 ORDER BY `minOrder` ASC [ RunTime:0.045446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814031 ORDER BY `unit` DESC [ RunTime:0.016439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814031 LIMIT 2 [ RunTime:0.036515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814031 ORDER BY `minOrder` ASC [ RunTime:0.022958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811856 LIMIT 5 [ RunTime:0.022004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811856 ORDER BY `minOrder` ASC [ RunTime:0.022660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811856 ORDER BY `unit` DESC [ RunTime:0.044059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811856 LIMIT 2 [ RunTime:0.034869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811856 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811009 LIMIT 5 [ RunTime:0.039091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811009 ORDER BY `minOrder` ASC [ RunTime:0.005705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811009 ORDER BY `unit` DESC [ RunTime:0.034099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811009 LIMIT 2 [ RunTime:0.020909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811009 ORDER BY `minOrder` ASC [ RunTime:0.005185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920565 LIMIT 5 [ RunTime:0.022882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920565 ORDER BY `minOrder` ASC [ RunTime:0.020151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920565 ORDER BY `unit` DESC [ RunTime:0.010777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920565 LIMIT 2 [ RunTime:0.060053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920565 ORDER BY `minOrder` ASC [ RunTime:0.003014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916304 LIMIT 5 [ RunTime:0.016637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916304 ORDER BY `minOrder` ASC [ RunTime:0.016823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916304 ORDER BY `unit` DESC [ RunTime:0.009147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916304 LIMIT 2 [ RunTime:0.011719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916304 ORDER BY `minOrder` ASC [ RunTime:0.015703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915865 LIMIT 5 [ RunTime:0.038792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915865 ORDER BY `minOrder` ASC [ RunTime:0.009329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915865 ORDER BY `unit` DESC [ RunTime:0.014955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915865 LIMIT 2 [ RunTime:0.011360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915865 ORDER BY `minOrder` ASC [ RunTime:0.010914s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001860s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170524 LIMIT 5 [ RunTime:0.002557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170524 ORDER BY `minOrder` ASC [ RunTime:0.014182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170524 ORDER BY `unit` DESC [ RunTime:0.008080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170524 LIMIT 2 [ RunTime:0.008661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170524 ORDER BY `minOrder` ASC [ RunTime:0.002454s ]
select * from pdf where partno='1.5SMC11AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.009844s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.009485s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170524 AND `partno` = '1.5SMC11AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.012192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803144 [ RunTime:0.011025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262195 LIMIT 5 [ RunTime:0.019239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262195 ORDER BY `minOrder` ASC [ RunTime:0.022386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262195 ORDER BY `unit` DESC [ RunTime:0.006698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262195 LIMIT 2 [ RunTime:0.014033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262195 ORDER BY `minOrder` ASC [ RunTime:0.001138s ]
select * from pdf where partno='1.5SMC11A TR13 PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.006155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A TR13 PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.012310s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262195 AND `partno` = '1.5SMC11A TR13 PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.018013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674683 [ RunTime:0.010773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42259136 LIMIT 5 [ RunTime:0.015683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259136 ORDER BY `minOrder` ASC [ RunTime:0.019933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42259136 ORDER BY `unit` DESC [ RunTime:0.019731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42259136 LIMIT 2 [ RunTime:0.009233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259136 ORDER BY `minOrder` ASC [ RunTime:0.020061s ]
select * from pdf where partno='1.5SMC11A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.030425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.023855s ]
SELECT `id` FROM `stock` WHERE `id` <> 42259136 AND `partno` = '1.5SMC11A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.023727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673558 [ RunTime:0.011625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257681 LIMIT 5 [ RunTime:0.009229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257681 ORDER BY `minOrder` ASC [ RunTime:0.011342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257681 ORDER BY `unit` DESC [ RunTime:0.014137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257681 LIMIT 2 [ RunTime:0.010832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257681 ORDER BY `minOrder` ASC [ RunTime:0.012554s ]
select * from pdf where partno='1.5SMC11A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030039s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257681 AND `partno` = '1.5SMC11A-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.037434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920565 [ RunTime:0.018005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257527 LIMIT 5 [ RunTime:0.012945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257527 ORDER BY `minOrder` ASC [ RunTime:0.018110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257527 ORDER BY `unit` DESC [ RunTime:0.036034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257527 LIMIT 2 [ RunTime:0.024597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257527 ORDER BY `minOrder` ASC [ RunTime:0.005794s ]
select * from pdf where partno='1.5SMC11A-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A-M3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009480s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257527 AND `partno` = '1.5SMC11A-M3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.028435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815284 [ RunTime:0.031556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257501 LIMIT 5 [ RunTime:0.017639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257501 ORDER BY `minOrder` ASC [ RunTime:0.017136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257501 ORDER BY `unit` DESC [ RunTime:0.001122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257501 LIMIT 2 [ RunTime:0.026321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257501 ORDER BY `minOrder` ASC [ RunTime:0.003431s ]
select * from pdf where partno='1.5SMC11A-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A-M3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.028261s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257501 AND `partno` = '1.5SMC11A-M3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674611 [ RunTime:0.019629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42253817 LIMIT 5 [ RunTime:0.010811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42253817 ORDER BY `minOrder` ASC [ RunTime:0.013321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42253817 ORDER BY `unit` DESC [ RunTime:0.009148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42253817 LIMIT 2 [ RunTime:0.009091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42253817 ORDER BY `minOrder` ASC [ RunTime:0.008455s ]
select * from pdf where partno='1.5SMC11A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.016494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.012880s ]
SELECT `id` FROM `stock` WHERE `id` <> 42253817 AND `partno` = '1.5SMC11A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.018807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814118 [ RunTime:0.010568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246330 LIMIT 5 [ RunTime:0.005619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246330 ORDER BY `minOrder` ASC [ RunTime:0.012324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246330 ORDER BY `unit` DESC [ RunTime:0.002256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246330 LIMIT 2 [ RunTime:0.004913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246330 ORDER BY `minOrder` ASC [ RunTime:0.004865s ]
select * from pdf where partno='1.5SMC11A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.010341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.033349s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246330 AND `partno` = '1.5SMC11A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.037349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814047 [ RunTime:0.017711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246295 LIMIT 5 [ RunTime:0.017967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246295 ORDER BY `minOrder` ASC [ RunTime:0.017461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246295 ORDER BY `unit` DESC [ RunTime:0.030612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246295 LIMIT 2 [ RunTime:0.024142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246295 ORDER BY `minOrder` ASC [ RunTime:0.012662s ]
select * from pdf where partno='1.5SMC11AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.028714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.015667s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246295 AND `partno` = '1.5SMC11AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.026285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814031 [ RunTime:0.006567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245919 LIMIT 5 [ RunTime:0.026078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245919 ORDER BY `minOrder` ASC [ RunTime:0.019729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245919 ORDER BY `unit` DESC [ RunTime:0.023321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245919 LIMIT 2 [ RunTime:0.013874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245919 ORDER BY `minOrder` ASC [ RunTime:0.004853s ]
select * from pdf where partno='1.5SMC11A-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A-E3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021030s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245919 AND `partno` = '1.5SMC11A-E3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.027635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916304 [ RunTime:0.015630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245672 LIMIT 5 [ RunTime:0.009025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245672 ORDER BY `minOrder` ASC [ RunTime:0.020131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245672 ORDER BY `unit` DESC [ RunTime:0.016008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245672 LIMIT 2 [ RunTime:0.017312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245672 ORDER BY `minOrder` ASC [ RunTime:0.016391s ]
select * from pdf where partno='1.5SMC11A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.033565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.037875s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245672 AND `partno` = '1.5SMC11A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.039624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678748 [ RunTime:0.017187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242798 LIMIT 5 [ RunTime:0.026211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242798 ORDER BY `minOrder` ASC [ RunTime:0.019220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242798 ORDER BY `unit` DESC [ RunTime:0.011547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242798 LIMIT 2 [ RunTime:0.006851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242798 ORDER BY `minOrder` ASC [ RunTime:0.017291s ]
select * from pdf where partno='1.5SMC11A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.018051s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242798 AND `partno` = '1.5SMC11A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.056286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811856 [ RunTime:0.023108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227717 LIMIT 5 [ RunTime:0.043667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227717 ORDER BY `minOrder` ASC [ RunTime:0.020873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227717 ORDER BY `unit` DESC [ RunTime:0.010648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227717 LIMIT 2 [ RunTime:0.020397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227717 ORDER BY `minOrder` ASC [ RunTime:0.016174s ]
select * from pdf where partno='1.5SMC11A-AT/7' and brandshort='YAGEO' limit 1 [ RunTime:0.045871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A-AT/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.042005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227137 LIMIT 5 [ RunTime:0.044200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227137 ORDER BY `minOrder` ASC [ RunTime:0.036927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227137 ORDER BY `unit` DESC [ RunTime:0.011603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227137 LIMIT 2 [ RunTime:0.027968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227137 ORDER BY `minOrder` ASC [ RunTime:0.014497s ]
select * from pdf where partno='1.5SMC11A-AT/13' and brandshort='YAGEO' limit 1 [ RunTime:0.025123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A-AT/13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.023658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222588 LIMIT 5 [ RunTime:0.069470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222588 ORDER BY `minOrder` ASC [ RunTime:0.018241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222588 ORDER BY `unit` DESC [ RunTime:0.066482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222588 LIMIT 2 [ RunTime:0.060300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222588 ORDER BY `minOrder` ASC [ RunTime:0.007427s ]
select * from pdf where partno='1.5SMC11A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.024553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.059447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221688 LIMIT 5 [ RunTime:0.019834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221688 ORDER BY `minOrder` ASC [ RunTime:0.016175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221688 ORDER BY `unit` DESC [ RunTime:0.006569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221688 LIMIT 2 [ RunTime:0.028997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221688 ORDER BY `minOrder` ASC [ RunTime:0.015359s ]
select * from pdf where partno='1.5SMC11A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.026129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC11A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025858s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.088002s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048550s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037323s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022418s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003400s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026524s ]
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 '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042313s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5SMC11A%' OR `brand` LIKE '1.5SMC11A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028484s ]