SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002511s ]
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=4768&search=1' [ RunTime:0.001978s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002297s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000600s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002753s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003872s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000381s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002308s ]
SELECT * FROM `stock_search` WHERE `partno` = '4768' LIMIT 1 [ RunTime:0.001267s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-15 23:04:30' WHERE `partno` = '4768' [ RunTime:0.004916s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003141s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007480s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14463679 LIMIT 5 [ RunTime:0.007311s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14463679 ORDER BY `minOrder` ASC [ RunTime:0.006203s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14463679 ORDER BY `unit` DESC [ RunTime:0.018893s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14463679 LIMIT 2 [ RunTime:0.005149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14463679 ORDER BY `minOrder` ASC [ RunTime:0.003000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13248944 LIMIT 5 [ RunTime:0.005555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13248944 ORDER BY `minOrder` ASC [ RunTime:0.015546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13248944 ORDER BY `unit` DESC [ RunTime:0.003576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13248944 LIMIT 2 [ RunTime:0.010528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13248944 ORDER BY `minOrder` ASC [ RunTime:0.003437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15236849 LIMIT 5 [ RunTime:0.001816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15236849 ORDER BY `minOrder` ASC [ RunTime:0.007009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15236849 ORDER BY `unit` DESC [ RunTime:0.015941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15236849 LIMIT 2 [ RunTime:0.015085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15236849 ORDER BY `minOrder` ASC [ RunTime:0.008715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18839596 LIMIT 5 [ RunTime:0.004756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18839596 ORDER BY `minOrder` ASC [ RunTime:0.008376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18839596 ORDER BY `unit` DESC [ RunTime:0.005864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18839596 LIMIT 2 [ RunTime:0.010011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18839596 ORDER BY `minOrder` ASC [ RunTime:0.005639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18838976 LIMIT 5 [ RunTime:0.021522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18838976 ORDER BY `minOrder` ASC [ RunTime:0.007424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18838976 ORDER BY `unit` DESC [ RunTime:0.002255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18838976 LIMIT 2 [ RunTime:0.013497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18838976 ORDER BY `minOrder` ASC [ RunTime:0.005663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18839078 LIMIT 5 [ RunTime:0.011019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18839078 ORDER BY `minOrder` ASC [ RunTime:0.004468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18839078 ORDER BY `unit` DESC [ RunTime:0.014106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18839078 LIMIT 2 [ RunTime:0.014021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18839078 ORDER BY `minOrder` ASC [ RunTime:0.007372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18718606 LIMIT 5 [ RunTime:0.012241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18718606 ORDER BY `minOrder` ASC [ RunTime:0.016035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18718606 ORDER BY `unit` DESC [ RunTime:0.012486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18718606 LIMIT 2 [ RunTime:0.019046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18718606 ORDER BY `minOrder` ASC [ RunTime:0.003965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16391986 LIMIT 5 [ RunTime:0.011036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16391986 ORDER BY `minOrder` ASC [ RunTime:0.006101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16391986 ORDER BY `unit` DESC [ RunTime:0.017646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16391986 LIMIT 2 [ RunTime:0.010251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16391986 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
select * from pdf where partno='47681SC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.010957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16388335 LIMIT 5 [ RunTime:0.014255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16388335 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16388335 ORDER BY `unit` DESC [ RunTime:0.007549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16388335 LIMIT 2 [ RunTime:0.001398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16388335 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='47680C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.002972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14713150 LIMIT 5 [ RunTime:0.008206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14713150 ORDER BY `minOrder` ASC [ RunTime:0.001537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14713150 ORDER BY `unit` DESC [ RunTime:0.005637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14713150 LIMIT 2 [ RunTime:0.004612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14713150 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
select * from pdf where partno='4768A99H73' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394241 LIMIT 5 [ RunTime:0.010793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394241 ORDER BY `minOrder` ASC [ RunTime:0.004671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394241 ORDER BY `unit` DESC [ RunTime:0.003610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394241 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394241 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13452411 LIMIT 5 [ RunTime:0.001108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13452411 ORDER BY `minOrder` ASC [ RunTime:0.010588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13452411 ORDER BY `unit` DESC [ RunTime:0.013969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13452411 LIMIT 2 [ RunTime:0.006522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13452411 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='47680SC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13328574 LIMIT 5 [ RunTime:0.012760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13328574 ORDER BY `minOrder` ASC [ RunTime:0.007421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13328574 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13328574 LIMIT 2 [ RunTime:0.005259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13328574 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13248611 LIMIT 5 [ RunTime:0.000896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13248611 ORDER BY `minOrder` ASC [ RunTime:0.006492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13248611 ORDER BY `unit` DESC [ RunTime:0.001515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13248611 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13248611 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13248610 LIMIT 5 [ RunTime:0.003102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13248610 ORDER BY `minOrder` ASC [ RunTime:0.002823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13248610 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13248610 LIMIT 2 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13248610 ORDER BY `minOrder` ASC [ RunTime:0.001930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13248609 LIMIT 5 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13248609 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13248609 ORDER BY `unit` DESC [ RunTime:0.000561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13248609 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13248609 ORDER BY `minOrder` ASC [ RunTime:0.008365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11977854 LIMIT 5 [ RunTime:0.002930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11977854 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11977854 ORDER BY `unit` DESC [ RunTime:0.000754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11977854 LIMIT 2 [ RunTime:0.001715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11977854 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004524s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62251133 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62251133 ORDER BY `minOrder` ASC [ RunTime:0.006573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62251133 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62251133 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62251133 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
select * from pdf where partno='4768' and brandshort='Pololu' limit 1 [ RunTime:0.003694s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4768' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.001272s ]
SELECT `id` FROM `stock` WHERE `id` <> 62251133 AND `partno` = '4768' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.002588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14463679 [ RunTime:0.004453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64173216 LIMIT 5 [ RunTime:0.003791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64173216 ORDER BY `minOrder` ASC [ RunTime:0.001042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64173216 ORDER BY `unit` DESC [ RunTime:0.002458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64173216 LIMIT 2 [ RunTime:0.006218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64173216 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='4768-10' and brandshort='Amphenol Narda-MITEQ' limit 1 [ RunTime:0.003586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4768-10' OR `brand` LIKE 'Amphenol Narda-MITEQ%' ) ) LIMIT 1 [ RunTime:0.004035s ]
SELECT `id` FROM `stock` WHERE `id` <> 64173216 AND `partno` = '4768-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol narda-miteq%' ) [ RunTime:0.000583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63519200 LIMIT 5 [ RunTime:0.002446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63519200 ORDER BY `minOrder` ASC [ RunTime:0.001686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63519200 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63519200 LIMIT 2 [ RunTime:0.002218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63519200 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
select * from pdf where partno='4768-K-36' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.001122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4768-K-36' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.005718s ]
SELECT `id` FROM `stock` WHERE `id` <> 63519200 AND `partno` = '4768-K-36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.004350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15236849 [ RunTime:0.000753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64510743 LIMIT 5 [ RunTime:0.002327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64510743 ORDER BY `minOrder` ASC [ RunTime:0.003536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64510743 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64510743 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64510743 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='47685' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47685' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000569s ]
SELECT `id` FROM `stock` WHERE `id` <> 64510743 AND `partno` = '47685' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394241 [ RunTime:0.006190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63519553 LIMIT 5 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63519553 ORDER BY `minOrder` ASC [ RunTime:0.000901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63519553 ORDER BY `unit` DESC [ RunTime:0.007249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63519553 LIMIT 2 [ RunTime:0.000798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63519553 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
select * from pdf where partno='4768-K-48' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.001132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4768-K-48' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.008590s ]
SELECT `id` FROM `stock` WHERE `id` <> 63519553 AND `partno` = '4768-K-48' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.001019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18839596 [ RunTime:0.003080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63140698 LIMIT 5 [ RunTime:0.002423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63140698 ORDER BY `minOrder` ASC [ RunTime:0.002265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63140698 ORDER BY `unit` DESC [ RunTime:0.000720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63140698 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63140698 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='4768' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4768' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.003263s ]
SELECT `id` FROM `stock` WHERE `id` <> 63140698 AND `partno` = '4768' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.002719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623293 LIMIT 5 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623293 ORDER BY `minOrder` ASC [ RunTime:0.001215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623293 ORDER BY `unit` DESC [ RunTime:0.000668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623293 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623293 ORDER BY `minOrder` ASC [ RunTime:0.005780s ]
select * from pdf where partno='4768.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.002337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4768.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000842s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623293 AND `partno` = '4768.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.001016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58534194 LIMIT 5 [ RunTime:0.003338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58534194 ORDER BY `minOrder` ASC [ RunTime:0.009909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58534194 ORDER BY `unit` DESC [ RunTime:0.001014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58534194 LIMIT 2 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58534194 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='47689' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.000926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47689' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.005034s ]
SELECT `id` FROM `stock` WHERE `id` <> 58534194 AND `partno` = '47689' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.002088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44633186 LIMIT 5 [ RunTime:0.001459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44633186 ORDER BY `minOrder` ASC [ RunTime:0.001168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44633186 ORDER BY `unit` DESC [ RunTime:0.000610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44633186 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44633186 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
select * from pdf where partno='47689' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.006705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47689' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002953s ]
SELECT `id` FROM `stock` WHERE `id` <> 44633186 AND `partno` = '47689' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18718606 [ RunTime:0.010448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40546847 LIMIT 5 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546847 ORDER BY `minOrder` ASC [ RunTime:0.001204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40546847 ORDER BY `unit` DESC [ RunTime:0.000665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40546847 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546847 ORDER BY `minOrder` ASC [ RunTime:0.009762s ]
select * from pdf where partno='47680C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.003728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47680C' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.002327s ]
SELECT `id` FROM `stock` WHERE `id` <> 40546847 AND `partno` = '47680C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.001862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16388335 [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40546013 LIMIT 5 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546013 ORDER BY `minOrder` ASC [ RunTime:0.003846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40546013 ORDER BY `unit` DESC [ RunTime:0.005710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40546013 LIMIT 2 [ RunTime:0.002028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546013 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='47681SC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.000589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47681SC' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.001753s ]
SELECT `id` FROM `stock` WHERE `id` <> 40546013 AND `partno` = '47681SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.000941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16391986 [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40546012 LIMIT 5 [ RunTime:0.001322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546012 ORDER BY `minOrder` ASC [ RunTime:0.004850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40546012 ORDER BY `unit` DESC [ RunTime:0.001274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40546012 LIMIT 2 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546012 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='47680SC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.000592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47680SC' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.000793s ]
SELECT `id` FROM `stock` WHERE `id` <> 40546012 AND `partno` = '47680SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.000838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13452411 [ RunTime:0.000674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33114905 LIMIT 5 [ RunTime:0.002767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33114905 ORDER BY `minOrder` ASC [ RunTime:0.003200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33114905 ORDER BY `unit` DESC [ RunTime:0.000921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33114905 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33114905 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='47689' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47689' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000429s ]
SELECT `id` FROM `stock` WHERE `id` <> 33114905 AND `partno` = '47689' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18718606 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32617467 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32617467 ORDER BY `minOrder` ASC [ RunTime:0.011278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32617467 ORDER BY `unit` DESC [ RunTime:0.001305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32617467 LIMIT 2 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32617467 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='476819-000' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476819-000' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002594s ]
SELECT `id` FROM `stock` WHERE `id` <> 32617467 AND `partno` = '476819-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32610499 LIMIT 5 [ RunTime:0.002728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32610499 ORDER BY `minOrder` ASC [ RunTime:0.002938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32610499 ORDER BY `unit` DESC [ RunTime:0.000553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32610499 LIMIT 2 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32610499 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
select * from pdf where partno='47689002' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47689002' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003430s ]
SELECT `id` FROM `stock` WHERE `id` <> 32610499 AND `partno` = '47689002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002114s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001452s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000613s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003519s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000952s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000577s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007170s ]
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 '4768%' OR `brand` LIKE '4768%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001031s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4768%' OR `brand` LIKE '4768%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000678s ]