SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001339s ]
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=228&page=57&srecordnum=10000' [ RunTime:0.004189s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001458s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004258s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003521s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001841s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002097s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.003477s ]
UPDATE `stock_search` SET `count` = 1166 , `updatetime` = '2026-06-11 23:21:18' WHERE `partno` = '228' [ RunTime:0.007812s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000284s ]
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.000466s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002315s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.242824s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1120,20 [ RunTime:0.126337s ]
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 ('32925761','32925760','32925759','32925758','32925757','32925756','32925755','32925754','32925753','32925752','32925751','32925750','32925749','32925748','32925747','32925746','32925745','32925744','32925743','32925742') ORDER BY FIELD(s.id, 32925761,32925760,32925759,32925758,32925757,32925756,32925755,32925754,32925753,32925752,32925751,32925750,32925749,32925748,32925747,32925746,32925745,32925744,32925743,32925742) [ RunTime:0.007747s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925761 LIMIT 4 [ RunTime:0.000960s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925761 ORDER BY `minOrder` ASC [ RunTime:0.003064s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925761 ORDER BY `unit` DESC [ RunTime:0.001759s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925761 LIMIT 2 [ RunTime:0.002595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925761 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
select * from pdf where partno='228ADS1AGFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009714s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001698s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925761 AND `partno` = '228ADS1AGFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449854 [ RunTime:0.004211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925760 LIMIT 4 [ RunTime:0.008997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925760 ORDER BY `minOrder` ASC [ RunTime:0.010390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925760 ORDER BY `unit` DESC [ RunTime:0.002709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925760 LIMIT 2 [ RunTime:0.012425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925760 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='228ADS1AGFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009602s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925760 AND `partno` = '228ADS1AGFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366524 [ RunTime:0.006585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925759 LIMIT 4 [ RunTime:0.004132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925759 ORDER BY `minOrder` ASC [ RunTime:0.000957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925759 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925759 LIMIT 2 [ RunTime:0.009454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925759 ORDER BY `minOrder` ASC [ RunTime:0.015867s ]
select * from pdf where partno='228ADS1AAWFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000709s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925759 AND `partno` = '228ADS1AAWFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.000663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366523 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925758 LIMIT 4 [ RunTime:0.001337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925758 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925758 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925758 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925758 ORDER BY `minOrder` ASC [ RunTime:0.008761s ]
select * from pdf where partno='228ADS1ABFCAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003574s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925758 AND `partno` = '228ADS1ABFCAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449853 [ RunTime:0.013738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925757 LIMIT 4 [ RunTime:0.004434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925757 ORDER BY `minOrder` ASC [ RunTime:0.004227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925757 ORDER BY `unit` DESC [ RunTime:0.003804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925757 LIMIT 2 [ RunTime:0.017593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925757 ORDER BY `minOrder` ASC [ RunTime:0.008348s ]
select * from pdf where partno='228ADS1ABFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004252s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925757 AND `partno` = '228ADS1ABFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.000956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366522 [ RunTime:0.010067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925756 LIMIT 4 [ RunTime:0.007111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925756 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925756 ORDER BY `unit` DESC [ RunTime:0.004655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925756 LIMIT 2 [ RunTime:0.008163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925756 ORDER BY `minOrder` ASC [ RunTime:0.001910s ]
select * from pdf where partno='228ADS1AGFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013109s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925756 AND `partno` = '228ADS1AGFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.004566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449852 [ RunTime:0.001058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925755 LIMIT 4 [ RunTime:0.001290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925755 ORDER BY `minOrder` ASC [ RunTime:0.008882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925755 ORDER BY `unit` DESC [ RunTime:0.005479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925755 LIMIT 2 [ RunTime:0.007764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925755 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
select * from pdf where partno='228ADS1AAWFCMSE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCMSE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008244s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925755 AND `partno` = '228ADS1AAWFCMSE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925754 LIMIT 4 [ RunTime:0.005867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925754 ORDER BY `minOrder` ASC [ RunTime:0.001231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925754 ORDER BY `unit` DESC [ RunTime:0.006589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925754 LIMIT 2 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925754 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='228ADS1AGFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003787s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925754 AND `partno` = '228ADS1AGFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925753 LIMIT 4 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925753 ORDER BY `minOrder` ASC [ RunTime:0.003444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925753 ORDER BY `unit` DESC [ RunTime:0.003313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925753 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925753 ORDER BY `minOrder` ASC [ RunTime:0.002989s ]
select * from pdf where partno='228ADS1ARGFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003824s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925753 AND `partno` = '228ADS1ARGFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925752 LIMIT 4 [ RunTime:0.006814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925752 ORDER BY `minOrder` ASC [ RunTime:0.003829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925752 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925752 LIMIT 2 [ RunTime:0.001280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925752 ORDER BY `minOrder` ASC [ RunTime:0.002790s ]
select * from pdf where partno='228ADS1AWFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003368s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925752 AND `partno` = '228ADS1AWFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.000681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925751 LIMIT 4 [ RunTime:0.002836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925751 ORDER BY `minOrder` ASC [ RunTime:0.006628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925751 ORDER BY `unit` DESC [ RunTime:0.005619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925751 LIMIT 2 [ RunTime:0.002731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925751 ORDER BY `minOrder` ASC [ RunTime:0.004059s ]
select * from pdf where partno='228ADS1AWFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001171s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925751 AND `partno` = '228ADS1AWFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925750 LIMIT 4 [ RunTime:0.002846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925750 ORDER BY `minOrder` ASC [ RunTime:0.006527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925750 ORDER BY `unit` DESC [ RunTime:0.001738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925750 LIMIT 2 [ RunTime:0.008392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925750 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='228ADS1AGFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.000878s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925750 AND `partno` = '228ADS1AGFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449851 [ RunTime:0.009911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925749 LIMIT 4 [ RunTime:0.001996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925749 ORDER BY `minOrder` ASC [ RunTime:0.001336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925749 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925749 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925749 ORDER BY `minOrder` ASC [ RunTime:0.001400s ]
select * from pdf where partno='228ADS1ARGFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014419s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925749 AND `partno` = '228ADS1ARGFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.003352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449850 [ RunTime:0.002243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925748 LIMIT 4 [ RunTime:0.003750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925748 ORDER BY `minOrder` ASC [ RunTime:0.017420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925748 ORDER BY `unit` DESC [ RunTime:0.005323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925748 LIMIT 2 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925748 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='228ADS1ABFCRE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCRE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.003739s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925748 AND `partno` = '228ADS1ABFCRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.001965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449849 [ RunTime:0.003620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925747 LIMIT 4 [ RunTime:0.008265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925747 ORDER BY `minOrder` ASC [ RunTime:0.005237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925747 ORDER BY `unit` DESC [ RunTime:0.006969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925747 LIMIT 2 [ RunTime:0.003322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925747 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='228ADS1AGFCMBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010332s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925747 AND `partno` = '228ADS1AGFCMBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449848 [ RunTime:0.012041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925746 LIMIT 4 [ RunTime:0.003941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925746 ORDER BY `minOrder` ASC [ RunTime:0.011232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925746 ORDER BY `unit` DESC [ RunTime:0.003825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925746 LIMIT 2 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925746 ORDER BY `minOrder` ASC [ RunTime:0.007544s ]
select * from pdf where partno='228ADS1ABFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ABFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016202s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925746 AND `partno` = '228ADS1ABFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.019382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449847 [ RunTime:0.003043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925745 LIMIT 4 [ RunTime:0.003752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925745 ORDER BY `minOrder` ASC [ RunTime:0.013397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925745 ORDER BY `unit` DESC [ RunTime:0.006316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925745 LIMIT 2 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925745 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
select * from pdf where partno='228ADS1AWFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.000897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007402s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925745 AND `partno` = '228ADS1AWFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449846 [ RunTime:0.003890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925744 LIMIT 4 [ RunTime:0.001545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925744 ORDER BY `minOrder` ASC [ RunTime:0.000791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925744 ORDER BY `unit` DESC [ RunTime:0.003399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925744 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925744 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='228ADS1AGFCMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004971s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925744 AND `partno` = '228ADS1AGFCMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.025813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449845 [ RunTime:0.008060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925743 LIMIT 4 [ RunTime:0.011419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925743 ORDER BY `minOrder` ASC [ RunTime:0.001096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925743 ORDER BY `unit` DESC [ RunTime:0.003730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925743 LIMIT 2 [ RunTime:0.007612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925743 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='228ADS1AGFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AGFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004480s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925743 AND `partno` = '228ADS1AGFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449844 [ RunTime:0.003310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925742 LIMIT 4 [ RunTime:0.004885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925742 ORDER BY `minOrder` ASC [ RunTime:0.002152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925742 ORDER BY `unit` DESC [ RunTime:0.003243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925742 LIMIT 2 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925742 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='228ADS1ARGFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006246s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925742 AND `partno` = '228ADS1ARGFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002049s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.094419s ]