SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001172s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=50201&search=1' [ RunTime:0.022612s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002212s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004885s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001230s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003655s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001127s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.042552s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001145s ]
SELECT * FROM `stock_search` WHERE `partno` = '50201' LIMIT 1 [ RunTime:0.041134s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-23 02:05:51' WHERE `partno` = '50201' [ RunTime:0.010152s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002623s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016643s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.020064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669726 LIMIT 5 [ RunTime:0.024107s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669726 ORDER BY `minOrder` ASC [ RunTime:0.032386s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.017779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669726 ORDER BY `unit` DESC [ RunTime:0.046245s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669726 LIMIT 2 [ RunTime:0.033978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669726 ORDER BY `minOrder` ASC [ RunTime:0.025062s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021884s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60332276 LIMIT 5 [ RunTime:0.036214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60332276 ORDER BY `minOrder` ASC [ RunTime:0.021931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60332276 ORDER BY `unit` DESC [ RunTime:0.037931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60332276 LIMIT 2 [ RunTime:0.047179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60332276 ORDER BY `minOrder` ASC [ RunTime:0.001111s ]
select * from pdf where partno='50201120' and brandshort='LAPP' limit 1 [ RunTime:0.033400s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201120' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.012807s ]
SELECT `id` FROM `stock` WHERE `id` <> 60332276 AND `partno` = '50201120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.027873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60328645 LIMIT 5 [ RunTime:0.048177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60328645 ORDER BY `minOrder` ASC [ RunTime:0.029684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60328645 ORDER BY `unit` DESC [ RunTime:0.027994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60328645 LIMIT 2 [ RunTime:0.061912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60328645 ORDER BY `minOrder` ASC [ RunTime:0.015007s ]
select * from pdf where partno='50201203' and brandshort='LAPP' limit 1 [ RunTime:0.029218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201203' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.024099s ]
SELECT `id` FROM `stock` WHERE `id` <> 60328645 AND `partno` = '50201203' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.036338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58321393 LIMIT 5 [ RunTime:0.058476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58321393 ORDER BY `minOrder` ASC [ RunTime:0.013679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58321393 ORDER BY `unit` DESC [ RunTime:0.020347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58321393 LIMIT 2 [ RunTime:0.015856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58321393 ORDER BY `minOrder` ASC [ RunTime:0.011550s ]
select * from pdf where partno='50201038' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201038' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011822s ]
SELECT `id` FROM `stock` WHERE `id` <> 58321393 AND `partno` = '50201038' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.014306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58320623 LIMIT 5 [ RunTime:0.028023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58320623 ORDER BY `minOrder` ASC [ RunTime:0.015344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58320623 ORDER BY `unit` DESC [ RunTime:0.003176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58320623 LIMIT 2 [ RunTime:0.005615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58320623 ORDER BY `minOrder` ASC [ RunTime:0.019533s ]
select * from pdf where partno='50201031' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201031' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015854s ]
SELECT `id` FROM `stock` WHERE `id` <> 58320623 AND `partno` = '50201031' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32505009 LIMIT 5 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32505009 ORDER BY `minOrder` ASC [ RunTime:0.004924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32505009 ORDER BY `unit` DESC [ RunTime:0.002549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32505009 LIMIT 2 [ RunTime:0.004442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32505009 ORDER BY `minOrder` ASC [ RunTime:0.010581s ]
select * from pdf where partno='50201127' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201127' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010690s ]
SELECT `id` FROM `stock` WHERE `id` <> 32505009 AND `partno` = '50201127' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32502703 LIMIT 5 [ RunTime:0.026086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32502703 ORDER BY `minOrder` ASC [ RunTime:0.021562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32502703 ORDER BY `unit` DESC [ RunTime:0.034674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32502703 LIMIT 2 [ RunTime:0.005097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32502703 ORDER BY `minOrder` ASC [ RunTime:0.002375s ]
select * from pdf where partno='50201084' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201084' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005332s ]
SELECT `id` FROM `stock` WHERE `id` <> 32502703 AND `partno` = '50201084' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32497998 LIMIT 5 [ RunTime:0.001979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32497998 ORDER BY `minOrder` ASC [ RunTime:0.009804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32497998 ORDER BY `unit` DESC [ RunTime:0.008119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32497998 LIMIT 2 [ RunTime:0.000985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32497998 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
select * from pdf where partno='50201011' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201011' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002360s ]
SELECT `id` FROM `stock` WHERE `id` <> 32497998 AND `partno` = '50201011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32466019 LIMIT 5 [ RunTime:0.002529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32466019 ORDER BY `minOrder` ASC [ RunTime:0.008880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32466019 ORDER BY `unit` DESC [ RunTime:0.008415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32466019 LIMIT 2 [ RunTime:0.000940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32466019 ORDER BY `minOrder` ASC [ RunTime:0.006843s ]
select * from pdf where partno='50201' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.002888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.010838s ]
SELECT `id` FROM `stock` WHERE `id` <> 32466019 AND `partno` = '50201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.012334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32451616 LIMIT 5 [ RunTime:0.009130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32451616 ORDER BY `minOrder` ASC [ RunTime:0.005428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32451616 ORDER BY `unit` DESC [ RunTime:0.002322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32451616 LIMIT 2 [ RunTime:0.008975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32451616 ORDER BY `minOrder` ASC [ RunTime:0.005594s ]
select * from pdf where partno='50201080' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201080' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007679s ]
SELECT `id` FROM `stock` WHERE `id` <> 32451616 AND `partno` = '50201080' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32450616 [ RunTime:0.009811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32450616 LIMIT 5 [ RunTime:0.003096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32450616 ORDER BY `minOrder` ASC [ RunTime:0.012200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32450616 ORDER BY `unit` DESC [ RunTime:0.001187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32450616 LIMIT 2 [ RunTime:0.002378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32450616 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='50201080' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201080' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006343s ]
SELECT `id` FROM `stock` WHERE `id` <> 32450616 AND `partno` = '50201080' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32451616 [ RunTime:0.008629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32420790 LIMIT 5 [ RunTime:0.003408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32420790 ORDER BY `minOrder` ASC [ RunTime:0.015592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32420790 ORDER BY `unit` DESC [ RunTime:0.004996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32420790 LIMIT 2 [ RunTime:0.018347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32420790 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='50201079' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201079' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013399s ]
SELECT `id` FROM `stock` WHERE `id` <> 32420790 AND `partno` = '50201079' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32417040 LIMIT 5 [ RunTime:0.002039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32417040 ORDER BY `minOrder` ASC [ RunTime:0.017072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32417040 ORDER BY `unit` DESC [ RunTime:0.010405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32417040 LIMIT 2 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32417040 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
select * from pdf where partno='50201123' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201123' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004565s ]
SELECT `id` FROM `stock` WHERE `id` <> 32417040 AND `partno` = '50201123' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32363170 LIMIT 5 [ RunTime:0.001573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32363170 ORDER BY `minOrder` ASC [ RunTime:0.005500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32363170 ORDER BY `unit` DESC [ RunTime:0.016610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32363170 LIMIT 2 [ RunTime:0.017729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32363170 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
select * from pdf where partno='50201085' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201085' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000865s ]
SELECT `id` FROM `stock` WHERE `id` <> 32363170 AND `partno` = '50201085' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32352452 LIMIT 5 [ RunTime:0.007476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32352452 ORDER BY `minOrder` ASC [ RunTime:0.013321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32352452 ORDER BY `unit` DESC [ RunTime:0.002560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32352452 LIMIT 2 [ RunTime:0.017857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32352452 ORDER BY `minOrder` ASC [ RunTime:0.007910s ]
select * from pdf where partno='50201114' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201114' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008922s ]
SELECT `id` FROM `stock` WHERE `id` <> 32352452 AND `partno` = '50201114' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.036922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32348379 LIMIT 5 [ RunTime:0.013782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32348379 ORDER BY `minOrder` ASC [ RunTime:0.014269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32348379 ORDER BY `unit` DESC [ RunTime:0.037566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32348379 LIMIT 2 [ RunTime:0.017095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32348379 ORDER BY `minOrder` ASC [ RunTime:0.016231s ]
select * from pdf where partno='50201089' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.023582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201089' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.021777s ]
SELECT `id` FROM `stock` WHERE `id` <> 32348379 AND `partno` = '50201089' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.082168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32346352 LIMIT 5 [ RunTime:0.063362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32346352 ORDER BY `minOrder` ASC [ RunTime:0.019173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32346352 ORDER BY `unit` DESC [ RunTime:0.012190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32346352 LIMIT 2 [ RunTime:0.046690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32346352 ORDER BY `minOrder` ASC [ RunTime:0.008357s ]
select * from pdf where partno='50201086' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.029181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201086' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.026051s ]
SELECT `id` FROM `stock` WHERE `id` <> 32346352 AND `partno` = '50201086' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.025265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32338791 LIMIT 5 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32338791 ORDER BY `minOrder` ASC [ RunTime:0.054446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32338791 ORDER BY `unit` DESC [ RunTime:0.067715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32338791 LIMIT 2 [ RunTime:0.045504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32338791 ORDER BY `minOrder` ASC [ RunTime:0.015395s ]
select * from pdf where partno='50201022' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.045569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201022' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.032203s ]
SELECT `id` FROM `stock` WHERE `id` <> 32338791 AND `partno` = '50201022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.037378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32329681 LIMIT 5 [ RunTime:0.054280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32329681 ORDER BY `minOrder` ASC [ RunTime:0.081542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32329681 ORDER BY `unit` DESC [ RunTime:0.006980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32329681 LIMIT 2 [ RunTime:0.056849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32329681 ORDER BY `minOrder` ASC [ RunTime:0.043952s ]
select * from pdf where partno='50201057' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.032401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201057' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.039727s ]
SELECT `id` FROM `stock` WHERE `id` <> 32329681 AND `partno` = '50201057' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.032866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32328046 LIMIT 5 [ RunTime:0.017092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32328046 ORDER BY `minOrder` ASC [ RunTime:0.059242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32328046 ORDER BY `unit` DESC [ RunTime:0.064068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32328046 LIMIT 2 [ RunTime:0.027638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32328046 ORDER BY `minOrder` ASC [ RunTime:0.019950s ]
select * from pdf where partno='50201073' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.039932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201073' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020895s ]
SELECT `id` FROM `stock` WHERE `id` <> 32328046 AND `partno` = '50201073' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.026272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32325022 LIMIT 5 [ RunTime:0.060837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325022 ORDER BY `minOrder` ASC [ RunTime:0.066828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32325022 ORDER BY `unit` DESC [ RunTime:0.053198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32325022 LIMIT 2 [ RunTime:0.038592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325022 ORDER BY `minOrder` ASC [ RunTime:0.022275s ]
select * from pdf where partno='50201061' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50201061' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.046134s ]
SELECT `id` FROM `stock` WHERE `id` <> 32325022 AND `partno` = '50201061' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.036845s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048242s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035049s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048039s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056101s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083740s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089851s ]
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 '50201%' OR `brand` LIKE '50201%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063027s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '50201%' OR `brand` LIKE '50201%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.048343s ]