SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002611s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=P1200&page=1&srecordnum=36' [ RunTime:0.003386s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002556s ]
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.002411s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002384s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000341s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.004053s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P1200' LIMIT 1 [ RunTime:0.008121s ]
UPDATE `stock_search` SET `count` = 18212 , `updatetime` = '2026-06-11 12:17:59' WHERE `partno` = 'P1200' [ RunTime:0.005131s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.005173s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006195s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.002788s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003959s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE 'P1200%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.044103s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'P1200%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021557s ]
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 ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32644337','14796004','13566938','35784611','703','37454282','37454243','37453826','37453227','32760100','32758950','32737457','32699759','32646080','32645935','32645760','32645694','32645621','32645400','32645345') ORDER BY FIELD(s.id, 32644337,14796004,13566938,35784611,703,37454282,37454243,37453826,37453227,32760100,32758950,32737457,32699759,32646080,32645935,32645760,32645694,32645621,32645400,32645345) [ RunTime:0.013589s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32644337 LIMIT 4 [ RunTime:0.000781s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32644337 ORDER BY `minOrder` ASC [ RunTime:0.002468s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32644337 ORDER BY `unit` DESC [ RunTime:0.004673s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32644337 LIMIT 2 [ RunTime:0.003541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32644337 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
select * from pdf where partno='P1200SALRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001969s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200SALRP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.002704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796004 LIMIT 4 [ RunTime:0.008008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796004 ORDER BY `minOrder` ASC [ RunTime:0.002033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14796004 ORDER BY `unit` DESC [ RunTime:0.014045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14796004 LIMIT 2 [ RunTime:0.003230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796004 ORDER BY `minOrder` ASC [ RunTime:0.000205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13566938 LIMIT 4 [ RunTime:0.001149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13566938 ORDER BY `minOrder` ASC [ RunTime:0.001617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13566938 ORDER BY `unit` DESC [ RunTime:0.002645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13566938 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13566938 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35784611 LIMIT 4 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35784611 ORDER BY `minOrder` ASC [ RunTime:0.007316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35784611 ORDER BY `unit` DESC [ RunTime:0.006691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35784611 LIMIT 2 [ RunTime:0.002711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35784611 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='P12001CEE-SJT' and brandshort='Ease Electronics' limit 1 [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P12001CEE-SJT' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.002868s ]
SELECT `id` FROM `stock` WHERE `id` <> 35784611 AND `partno` = 'P12001CEE-SJT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13566938 [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 703 LIMIT 4 [ RunTime:0.001204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 703 ORDER BY `minOrder` ASC [ RunTime:0.001055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 703 ORDER BY `unit` DESC [ RunTime:0.001843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 703 LIMIT 2 [ RunTime:0.004905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 703 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200' OR `brand` LIKE 'ETAL%' ) ) LIMIT 1 [ RunTime:0.000688s ]
SELECT `id` FROM `stock` WHERE `id` <> 703 AND `partno` = 'P1200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%etal%' ) [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37454282 LIMIT 4 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37454282 ORDER BY `minOrder` ASC [ RunTime:0.006989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37454282 ORDER BY `unit` DESC [ RunTime:0.005159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37454282 LIMIT 2 [ RunTime:0.002054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37454282 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='P1200AWKKI' and brandshort='Schneider Electric' limit 1 [ RunTime:0.002826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200AWKKI' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.001755s ]
SELECT `id` FROM `stock` WHERE `id` <> 37454282 AND `partno` = 'P1200AWKKI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.009887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32760100 [ RunTime:0.004124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37454243 LIMIT 4 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37454243 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37454243 ORDER BY `unit` DESC [ RunTime:0.009452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37454243 LIMIT 2 [ RunTime:0.001185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37454243 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
select * from pdf where partno='P1200AWK' and brandshort='Schneider Electric' limit 1 [ RunTime:0.001560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200AWK' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.003287s ]
SELECT `id` FROM `stock` WHERE `id` <> 37454243 AND `partno` = 'P1200AWK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.008799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32758950 [ RunTime:0.007176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37453826 LIMIT 4 [ RunTime:0.002256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37453826 ORDER BY `minOrder` ASC [ RunTime:0.002877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37453826 ORDER BY `unit` DESC [ RunTime:0.001282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37453826 LIMIT 2 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37453826 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='P1200R' and brandshort='Schneider Electric' limit 1 [ RunTime:0.001441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200R' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.001441s ]
SELECT `id` FROM `stock` WHERE `id` <> 37453826 AND `partno` = 'P1200R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.002901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32737457 [ RunTime:0.003145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37453227 LIMIT 4 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37453227 ORDER BY `minOrder` ASC [ RunTime:0.007127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37453227 ORDER BY `unit` DESC [ RunTime:0.001961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37453227 LIMIT 2 [ RunTime:0.002913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37453227 ORDER BY `minOrder` ASC [ RunTime:0.004562s ]
select * from pdf where partno='P1200S' and brandshort='Schneider Electric' limit 1 [ RunTime:0.002515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200S' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.005646s ]
SELECT `id` FROM `stock` WHERE `id` <> 37453227 AND `partno` = 'P1200S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.003417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32699759 [ RunTime:0.004161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32760100 LIMIT 4 [ RunTime:0.003993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32760100 ORDER BY `minOrder` ASC [ RunTime:0.005396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32760100 ORDER BY `unit` DESC [ RunTime:0.003348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32760100 LIMIT 2 [ RunTime:0.001743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32760100 ORDER BY `minOrder` ASC [ RunTime:0.001229s ]
select * from pdf where partno='P1200AWKKI' and brandshort='Schneider Electric' limit 1 [ RunTime:0.000686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200AWKKI' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.002860s ]
SELECT `id` FROM `stock` WHERE `id` <> 32760100 AND `partno` = 'P1200AWKKI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.002455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37454282 [ RunTime:0.006632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32758950 LIMIT 4 [ RunTime:0.001944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32758950 ORDER BY `minOrder` ASC [ RunTime:0.001025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32758950 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32758950 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32758950 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='P1200AWK' and brandshort='Schneider Electric' limit 1 [ RunTime:0.000447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200AWK' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.000344s ]
SELECT `id` FROM `stock` WHERE `id` <> 32758950 AND `partno` = 'P1200AWK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.002963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37454243 [ RunTime:0.001540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32737457 LIMIT 4 [ RunTime:0.000986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32737457 ORDER BY `minOrder` ASC [ RunTime:0.007455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32737457 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32737457 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32737457 ORDER BY `minOrder` ASC [ RunTime:0.002148s ]
select * from pdf where partno='P1200R' and brandshort='Schneider Electric' limit 1 [ RunTime:0.000306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200R' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.000241s ]
SELECT `id` FROM `stock` WHERE `id` <> 32737457 AND `partno` = 'P1200R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37453826 [ RunTime:0.012673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32699759 LIMIT 4 [ RunTime:0.004537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32699759 ORDER BY `minOrder` ASC [ RunTime:0.004181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32699759 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32699759 LIMIT 2 [ RunTime:0.006704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32699759 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='P1200S' and brandshort='Schneider Electric' limit 1 [ RunTime:0.000455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200S' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.000266s ]
SELECT `id` FROM `stock` WHERE `id` <> 32699759 AND `partno` = 'P1200S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.001151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37453227 [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32646080 LIMIT 4 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32646080 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32646080 ORDER BY `unit` DESC [ RunTime:0.009422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32646080 LIMIT 2 [ RunTime:0.003268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32646080 ORDER BY `minOrder` ASC [ RunTime:0.009689s ]
select * from pdf where partno='P1200Q22CLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.010444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200Q22CLRP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32645935 LIMIT 4 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645935 ORDER BY `minOrder` ASC [ RunTime:0.004741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32645935 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32645935 LIMIT 2 [ RunTime:0.005632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645935 ORDER BY `minOrder` ASC [ RunTime:0.003658s ]
select * from pdf where partno='P1200Q12BLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200Q12BLRP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003758s ]
SELECT `id` FROM `stock` WHERE `id` <> 32645935 AND `partno` = 'P1200Q12BLRP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901012 [ RunTime:0.001012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32645760 LIMIT 4 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645760 ORDER BY `minOrder` ASC [ RunTime:0.002632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32645760 ORDER BY `unit` DESC [ RunTime:0.001509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32645760 LIMIT 2 [ RunTime:0.004570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645760 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='P1200Q12ALRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200Q12ALRP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001046s ]
SELECT `id` FROM `stock` WHERE `id` <> 32645760 AND `partno` = 'P1200Q12ALRP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656985 [ RunTime:0.001976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32645694 LIMIT 4 [ RunTime:0.002894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645694 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32645694 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32645694 LIMIT 2 [ RunTime:0.006363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645694 ORDER BY `minOrder` ASC [ RunTime:0.005540s ]
select * from pdf where partno='P1200SCMCLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200SCMCLRP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32645621 LIMIT 4 [ RunTime:0.003458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645621 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32645621 ORDER BY `unit` DESC [ RunTime:0.002046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32645621 LIMIT 2 [ RunTime:0.001391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645621 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='P1200SCMC' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200SCMC' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000799s ]
SELECT `id` FROM `stock` WHERE `id` <> 32645621 AND `partno` = 'P1200SCMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.008141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14795407 [ RunTime:0.010519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32645400 LIMIT 4 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645400 ORDER BY `minOrder` ASC [ RunTime:0.000884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32645400 ORDER BY `unit` DESC [ RunTime:0.006489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32645400 LIMIT 2 [ RunTime:0.004012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645400 ORDER BY `minOrder` ASC [ RunTime:0.005731s ]
select * from pdf where partno='P1200SCLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200SCLRP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.017435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32645345 LIMIT 4 [ RunTime:0.002661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645345 ORDER BY `minOrder` ASC [ RunTime:0.012757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32645345 ORDER BY `unit` DESC [ RunTime:0.005597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32645345 LIMIT 2 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32645345 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='P1200SB' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200SB' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003905s ]
SELECT `id` FROM `stock` WHERE `id` <> 32645345 AND `partno` = 'P1200SB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900954 [ RunTime:0.012257s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'P1200%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.014789s ]