SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001434s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `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=21209&search=1' [ RunTime:0.006357s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003459s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016731s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002237s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.036962s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002054s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011528s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001983s ]
SELECT * FROM `stock_search` WHERE `partno` = '21209' LIMIT 1 [ RunTime:0.016425s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-29 06:31:04' WHERE `partno` = '21209' [ RunTime:0.019522s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002002s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052890s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13564793 LIMIT 5 [ RunTime:0.029615s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.017246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13564793 ORDER BY `minOrder` ASC [ RunTime:0.028658s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13564793 ORDER BY `unit` DESC [ RunTime:0.070810s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.023710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13564793 LIMIT 2 [ RunTime:0.102640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13564793 ORDER BY `minOrder` ASC [ RunTime:0.020782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14670799 LIMIT 5 [ RunTime:0.124315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670799 ORDER BY `minOrder` ASC [ RunTime:0.050178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14670799 ORDER BY `unit` DESC [ RunTime:0.114439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14670799 LIMIT 2 [ RunTime:0.053261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670799 ORDER BY `minOrder` ASC [ RunTime:0.040669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10892707 LIMIT 5 [ RunTime:0.006310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10892707 ORDER BY `minOrder` ASC [ RunTime:0.031666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10892707 ORDER BY `unit` DESC [ RunTime:0.030728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10892707 LIMIT 2 [ RunTime:0.124869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10892707 ORDER BY `minOrder` ASC [ RunTime:0.023298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10821994 LIMIT 5 [ RunTime:0.040676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10821994 ORDER BY `minOrder` ASC [ RunTime:0.089881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10821994 ORDER BY `unit` DESC [ RunTime:0.035567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10821994 LIMIT 2 [ RunTime:0.072533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10821994 ORDER BY `minOrder` ASC [ RunTime:0.063319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10821996 LIMIT 5 [ RunTime:0.061167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10821996 ORDER BY `minOrder` ASC [ RunTime:0.089825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10821996 ORDER BY `unit` DESC [ RunTime:0.151028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10821996 LIMIT 2 [ RunTime:0.108520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10821996 ORDER BY `minOrder` ASC [ RunTime:0.051681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14687468 LIMIT 5 [ RunTime:0.035337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687468 ORDER BY `minOrder` ASC [ RunTime:0.050332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14687468 ORDER BY `unit` DESC [ RunTime:0.073311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14687468 LIMIT 2 [ RunTime:0.029290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687468 ORDER BY `minOrder` ASC [ RunTime:0.001508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700664 LIMIT 5 [ RunTime:0.013558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700664 ORDER BY `minOrder` ASC [ RunTime:0.017486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700664 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700664 LIMIT 2 [ RunTime:0.021466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700664 ORDER BY `minOrder` ASC [ RunTime:0.050679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807309 LIMIT 5 [ RunTime:0.000757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807309 ORDER BY `minOrder` ASC [ RunTime:0.037606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13807309 ORDER BY `unit` DESC [ RunTime:0.032234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13807309 LIMIT 2 [ RunTime:0.057305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807309 ORDER BY `minOrder` ASC [ RunTime:0.006398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294610 LIMIT 5 [ RunTime:0.069975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294610 ORDER BY `minOrder` ASC [ RunTime:0.135119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13294610 ORDER BY `unit` DESC [ RunTime:0.008066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13294610 LIMIT 2 [ RunTime:0.035438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294610 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11796511 LIMIT 5 [ RunTime:0.051285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11796511 ORDER BY `minOrder` ASC [ RunTime:0.065482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11796511 ORDER BY `unit` DESC [ RunTime:0.028117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11796511 LIMIT 2 [ RunTime:0.065675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11796511 ORDER BY `minOrder` ASC [ RunTime:0.028364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11772515 LIMIT 5 [ RunTime:0.098572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11772515 ORDER BY `minOrder` ASC [ RunTime:0.016313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11772515 ORDER BY `unit` DESC [ RunTime:0.081817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11772515 LIMIT 2 [ RunTime:0.011142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11772515 ORDER BY `minOrder` ASC [ RunTime:0.021935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988530 LIMIT 5 [ RunTime:0.018869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988530 ORDER BY `minOrder` ASC [ RunTime:0.069808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10988530 ORDER BY `unit` DESC [ RunTime:0.069978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10988530 LIMIT 2 [ RunTime:0.042522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988530 ORDER BY `minOrder` ASC [ RunTime:0.046013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10901165 LIMIT 5 [ RunTime:0.031823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10901165 ORDER BY `minOrder` ASC [ RunTime:0.065529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10901165 ORDER BY `unit` DESC [ RunTime:0.102661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10901165 LIMIT 2 [ RunTime:0.061485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10901165 ORDER BY `minOrder` ASC [ RunTime:0.037427s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036474s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62419805 LIMIT 5 [ RunTime:0.032603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62419805 ORDER BY `minOrder` ASC [ RunTime:0.011318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62419805 ORDER BY `unit` DESC [ RunTime:0.061641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62419805 LIMIT 2 [ RunTime:0.053652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62419805 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='212099-01' and brandshort='Qualtek' limit 1 [ RunTime:0.032436s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212099-01' OR `brand` LIKE 'Qualtek%' ) ) LIMIT 1 [ RunTime:0.043901s ]
SELECT `id` FROM `stock` WHERE `id` <> 62419805 AND `partno` = '212099-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%qualtek%' ) [ RunTime:0.009107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13564793 [ RunTime:0.011481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61012395 LIMIT 5 [ RunTime:0.018420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61012395 ORDER BY `minOrder` ASC [ RunTime:0.021347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61012395 ORDER BY `unit` DESC [ RunTime:0.023446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61012395 LIMIT 2 [ RunTime:0.035971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61012395 ORDER BY `minOrder` ASC [ RunTime:0.035197s ]
select * from pdf where partno='2120950-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120950-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008577s ]
SELECT `id` FROM `stock` WHERE `id` <> 61012395 AND `partno` = '2120950-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10821994 [ RunTime:0.028810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61015203 LIMIT 5 [ RunTime:0.040599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61015203 ORDER BY `minOrder` ASC [ RunTime:0.018776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61015203 ORDER BY `unit` DESC [ RunTime:0.012102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61015203 LIMIT 2 [ RunTime:0.030952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61015203 ORDER BY `minOrder` ASC [ RunTime:0.015304s ]
select * from pdf where partno='2120948-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.041005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120948-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.032524s ]
SELECT `id` FROM `stock` WHERE `id` <> 61015203 AND `partno` = '2120948-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10821996 [ RunTime:0.046420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62133475 LIMIT 5 [ RunTime:0.041830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62133475 ORDER BY `minOrder` ASC [ RunTime:0.029676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62133475 ORDER BY `unit` DESC [ RunTime:0.024721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62133475 LIMIT 2 [ RunTime:0.019442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62133475 ORDER BY `minOrder` ASC [ RunTime:0.016898s ]
select * from pdf where partno='2120959-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.049495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120959-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.034092s ]
SELECT `id` FROM `stock` WHERE `id` <> 62133475 AND `partno` = '2120959-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.025673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14670799 [ RunTime:0.035724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62133448 LIMIT 5 [ RunTime:0.039884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62133448 ORDER BY `minOrder` ASC [ RunTime:0.043750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62133448 ORDER BY `unit` DESC [ RunTime:0.015935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62133448 LIMIT 2 [ RunTime:0.026193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62133448 ORDER BY `minOrder` ASC [ RunTime:0.012786s ]
select * from pdf where partno='2120958-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.031499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120958-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.023199s ]
SELECT `id` FROM `stock` WHERE `id` <> 62133448 AND `partno` = '2120958-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.043031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14687468 [ RunTime:0.029158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61329057 LIMIT 5 [ RunTime:0.022615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61329057 ORDER BY `minOrder` ASC [ RunTime:0.048017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61329057 ORDER BY `unit` DESC [ RunTime:0.024805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61329057 LIMIT 2 [ RunTime:0.010177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61329057 ORDER BY `minOrder` ASC [ RunTime:0.020083s ]
select * from pdf where partno='2120953-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120953-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.043648s ]
SELECT `id` FROM `stock` WHERE `id` <> 61329057 AND `partno` = '2120953-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.021449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11796511 [ RunTime:0.039552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61257197 LIMIT 5 [ RunTime:0.092155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61257197 ORDER BY `minOrder` ASC [ RunTime:0.051145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61257197 ORDER BY `unit` DESC [ RunTime:0.036889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61257197 LIMIT 2 [ RunTime:0.066571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61257197 ORDER BY `minOrder` ASC [ RunTime:0.116701s ]
select * from pdf where partno='2120949-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.083530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120949-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.084044s ]
SELECT `id` FROM `stock` WHERE `id` <> 61257197 AND `partno` = '2120949-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.053912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11772515 [ RunTime:0.142481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61256859 LIMIT 5 [ RunTime:0.068012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61256859 ORDER BY `minOrder` ASC [ RunTime:0.016785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61256859 ORDER BY `unit` DESC [ RunTime:0.036833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61256859 LIMIT 2 [ RunTime:0.089029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61256859 ORDER BY `minOrder` ASC [ RunTime:0.020354s ]
select * from pdf where partno='2120951-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120951-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017168s ]
SELECT `id` FROM `stock` WHERE `id` <> 61256859 AND `partno` = '2120951-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.047321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61018126 LIMIT 5 [ RunTime:0.037761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61018126 ORDER BY `minOrder` ASC [ RunTime:0.048920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61018126 ORDER BY `unit` DESC [ RunTime:0.029220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61018126 LIMIT 2 [ RunTime:0.043731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61018126 ORDER BY `minOrder` ASC [ RunTime:0.006227s ]
select * from pdf where partno='2120947-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120947-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008169s ]
SELECT `id` FROM `stock` WHERE `id` <> 61018126 AND `partno` = '2120947-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10892707 [ RunTime:0.016362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61016963 LIMIT 5 [ RunTime:0.008708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61016963 ORDER BY `minOrder` ASC [ RunTime:0.021882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61016963 ORDER BY `unit` DESC [ RunTime:0.017469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61016963 LIMIT 2 [ RunTime:0.007090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61016963 ORDER BY `minOrder` ASC [ RunTime:0.005611s ]
select * from pdf where partno='2120954-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120954-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012784s ]
SELECT `id` FROM `stock` WHERE `id` <> 61016963 AND `partno` = '2120954-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988530 [ RunTime:0.020932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58584518 LIMIT 5 [ RunTime:0.007386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58584518 ORDER BY `minOrder` ASC [ RunTime:0.015211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58584518 ORDER BY `unit` DESC [ RunTime:0.011530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58584518 LIMIT 2 [ RunTime:0.002090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58584518 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='21209' and brandshort='Wiha' limit 1 [ RunTime:0.000905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21209' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000826s ]
SELECT `id` FROM `stock` WHERE `id` <> 58584518 AND `partno` = '21209' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.002407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700664 [ RunTime:0.005380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54344881 LIMIT 5 [ RunTime:0.004088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54344881 ORDER BY `minOrder` ASC [ RunTime:0.008912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54344881 ORDER BY `unit` DESC [ RunTime:0.005645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54344881 LIMIT 2 [ RunTime:0.003853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54344881 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='2120946-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120946-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001161s ]
SELECT `id` FROM `stock` WHERE `id` <> 54344881 AND `partno` = '2120946-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10901165 [ RunTime:0.005136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32665559 LIMIT 5 [ RunTime:0.004709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32665559 ORDER BY `minOrder` ASC [ RunTime:0.008664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32665559 ORDER BY `unit` DESC [ RunTime:0.004360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32665559 LIMIT 2 [ RunTime:0.005422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32665559 ORDER BY `minOrder` ASC [ RunTime:0.000739s ]
select * from pdf where partno='2120914' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2120914' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004850s ]
SELECT `id` FROM `stock` WHERE `id` <> 32665559 AND `partno` = '2120914' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294610 [ RunTime:0.000328s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003941s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010913s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005349s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009025s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005155s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008083s ]
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 '21209%' OR `brand` LIKE '21209%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008918s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21209%' OR `brand` LIKE '21209%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003433s ]