SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.004913s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=SA1-K&search=1' [ RunTime:0.003042s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002974s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000662s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002586s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002492s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000917s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003121s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SA1-K' LIMIT 1 [ RunTime:0.001926s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 18:52:48' WHERE `partno` = 'SA1-K' [ RunTime:0.002684s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002736s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008457s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263845 LIMIT 5 [ RunTime:0.003946s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13263845 ORDER BY `minOrder` ASC [ RunTime:0.002385s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13263845 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13263845 LIMIT 2 [ RunTime:0.003323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13263845 ORDER BY `minOrder` ASC [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265517 LIMIT 5 [ RunTime:0.000836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265517 ORDER BY `minOrder` ASC [ RunTime:0.003691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265517 ORDER BY `unit` DESC [ RunTime:0.000529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265517 LIMIT 2 [ RunTime:0.005611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265517 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265556 LIMIT 5 [ RunTime:0.002454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265556 ORDER BY `minOrder` ASC [ RunTime:0.006955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265556 ORDER BY `unit` DESC [ RunTime:0.012262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265556 LIMIT 2 [ RunTime:0.002600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265556 ORDER BY `minOrder` ASC [ RunTime:0.001121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265456 LIMIT 5 [ RunTime:0.004971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265456 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265456 ORDER BY `unit` DESC [ RunTime:0.011451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265456 LIMIT 2 [ RunTime:0.004245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265456 ORDER BY `minOrder` ASC [ RunTime:0.006623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265361 LIMIT 5 [ RunTime:0.008333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265361 ORDER BY `minOrder` ASC [ RunTime:0.001273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265361 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265361 LIMIT 2 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265361 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265346 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265346 ORDER BY `minOrder` ASC [ RunTime:0.003437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265346 ORDER BY `unit` DESC [ RunTime:0.021853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265346 LIMIT 2 [ RunTime:0.019485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265346 ORDER BY `minOrder` ASC [ RunTime:0.003388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265320 LIMIT 5 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265320 ORDER BY `minOrder` ASC [ RunTime:0.002581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265320 ORDER BY `unit` DESC [ RunTime:0.000272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265320 LIMIT 2 [ RunTime:0.002642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265320 ORDER BY `minOrder` ASC [ RunTime:0.002743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992003 LIMIT 5 [ RunTime:0.003030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11992003 ORDER BY `minOrder` ASC [ RunTime:0.001468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11992003 ORDER BY `unit` DESC [ RunTime:0.018284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11992003 LIMIT 2 [ RunTime:0.009763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11992003 ORDER BY `minOrder` ASC [ RunTime:0.008248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991894 LIMIT 5 [ RunTime:0.001705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991894 ORDER BY `minOrder` ASC [ RunTime:0.006969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11991894 ORDER BY `unit` DESC [ RunTime:0.029797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11991894 LIMIT 2 [ RunTime:0.008807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991894 ORDER BY `minOrder` ASC [ RunTime:0.003909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991889 LIMIT 5 [ RunTime:0.006728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991889 ORDER BY `minOrder` ASC [ RunTime:0.022329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11991889 ORDER BY `unit` DESC [ RunTime:0.003161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11991889 LIMIT 2 [ RunTime:0.010597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991889 ORDER BY `minOrder` ASC [ RunTime:0.003145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991885 LIMIT 5 [ RunTime:0.018345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991885 ORDER BY `minOrder` ASC [ RunTime:0.012089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11991885 ORDER BY `unit` DESC [ RunTime:0.007724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11991885 LIMIT 2 [ RunTime:0.012415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991885 ORDER BY `minOrder` ASC [ RunTime:0.014028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991840 LIMIT 5 [ RunTime:0.005736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991840 ORDER BY `minOrder` ASC [ RunTime:0.005692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11991840 ORDER BY `unit` DESC [ RunTime:0.008676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11991840 LIMIT 2 [ RunTime:0.014301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991840 ORDER BY `minOrder` ASC [ RunTime:0.001711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991790 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991790 ORDER BY `minOrder` ASC [ RunTime:0.012039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11991790 ORDER BY `unit` DESC [ RunTime:0.001395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11991790 LIMIT 2 [ RunTime:0.001024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991790 ORDER BY `minOrder` ASC [ RunTime:0.013676s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006760s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63236858 LIMIT 5 [ RunTime:0.003146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236858 ORDER BY `minOrder` ASC [ RunTime:0.017677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63236858 ORDER BY `unit` DESC [ RunTime:0.004497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63236858 LIMIT 2 [ RunTime:0.012360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236858 ORDER BY `minOrder` ASC [ RunTime:0.013893s ]
select * from pdf where partno='SA1-K-SRTC' and brandshort='Omega' limit 1 [ RunTime:0.044908s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-SRTC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.017647s ]
SELECT `id` FROM `stock` WHERE `id` <> 63236858 AND `partno` = 'SA1-K-SRTC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.033079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263845 [ RunTime:0.010537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63236857 LIMIT 5 [ RunTime:0.017506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236857 ORDER BY `minOrder` ASC [ RunTime:0.031554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63236857 ORDER BY `unit` DESC [ RunTime:0.012085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63236857 LIMIT 2 [ RunTime:0.032521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236857 ORDER BY `minOrder` ASC [ RunTime:0.003250s ]
select * from pdf where partno='SA1-K' and brandshort='Omega' limit 1 [ RunTime:0.019591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.013697s ]
SELECT `id` FROM `stock` WHERE `id` <> 63236857 AND `partno` = 'SA1-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.037498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992003 [ RunTime:0.024567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63236870 LIMIT 5 [ RunTime:0.005663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236870 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63236870 ORDER BY `unit` DESC [ RunTime:0.003141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63236870 LIMIT 2 [ RunTime:0.008027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236870 ORDER BY `minOrder` ASC [ RunTime:0.014604s ]
select * from pdf where partno='SA1-K-72-SRTC' and brandshort='Omega' limit 1 [ RunTime:0.003654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-72-SRTC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.004633s ]
SELECT `id` FROM `stock` WHERE `id` <> 63236870 AND `partno` = 'SA1-K-72-SRTC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.016429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265456 [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63236873 LIMIT 5 [ RunTime:0.001730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236873 ORDER BY `minOrder` ASC [ RunTime:0.011282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63236873 ORDER BY `unit` DESC [ RunTime:0.011641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63236873 LIMIT 2 [ RunTime:0.001506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236873 ORDER BY `minOrder` ASC [ RunTime:0.002463s ]
select * from pdf where partno='SA1-K-120-SRTC' and brandshort='Omega' limit 1 [ RunTime:0.014579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-120-SRTC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.008173s ]
SELECT `id` FROM `stock` WHERE `id` <> 63236873 AND `partno` = 'SA1-K-120-SRTC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.015192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265556 [ RunTime:0.002964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63236944 LIMIT 5 [ RunTime:0.007220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236944 ORDER BY `minOrder` ASC [ RunTime:0.006990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63236944 ORDER BY `unit` DESC [ RunTime:0.002344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63236944 LIMIT 2 [ RunTime:0.001464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236944 ORDER BY `minOrder` ASC [ RunTime:0.002812s ]
select * from pdf where partno='SA1-K-72' and brandshort='Omega' limit 1 [ RunTime:0.011154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-72' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.025996s ]
SELECT `id` FROM `stock` WHERE `id` <> 63236944 AND `partno` = 'SA1-K-72' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.012379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265361 [ RunTime:0.008299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63236941 LIMIT 5 [ RunTime:0.005614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236941 ORDER BY `minOrder` ASC [ RunTime:0.007061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63236941 ORDER BY `unit` DESC [ RunTime:0.017843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63236941 LIMIT 2 [ RunTime:0.013129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236941 ORDER BY `minOrder` ASC [ RunTime:0.001402s ]
select * from pdf where partno='SA1-K-SC' and brandshort='Omega' limit 1 [ RunTime:0.011559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-SC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.022176s ]
SELECT `id` FROM `stock` WHERE `id` <> 63236941 AND `partno` = 'SA1-K-SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.016407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991840 [ RunTime:0.025662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63236871 LIMIT 5 [ RunTime:0.020289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236871 ORDER BY `minOrder` ASC [ RunTime:0.009846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63236871 ORDER BY `unit` DESC [ RunTime:0.014344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63236871 LIMIT 2 [ RunTime:0.010867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63236871 ORDER BY `minOrder` ASC [ RunTime:0.023562s ]
select * from pdf where partno='SA1-K-120' and brandshort='Omega' limit 1 [ RunTime:0.025911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-120' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.014906s ]
SELECT `id` FROM `stock` WHERE `id` <> 63236871 AND `partno` = 'SA1-K-120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.016216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265517 [ RunTime:0.010052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63237153 LIMIT 5 [ RunTime:0.002424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63237153 ORDER BY `minOrder` ASC [ RunTime:0.006412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63237153 ORDER BY `unit` DESC [ RunTime:0.005473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63237153 LIMIT 2 [ RunTime:0.011250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63237153 ORDER BY `minOrder` ASC [ RunTime:0.011341s ]
select * from pdf where partno='SA1-K-72-SC' and brandshort='Omega' limit 1 [ RunTime:0.019169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-72-SC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.018912s ]
SELECT `id` FROM `stock` WHERE `id` <> 63237153 AND `partno` = 'SA1-K-72-SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.012580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991885 [ RunTime:0.019958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267810 LIMIT 5 [ RunTime:0.021274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267810 ORDER BY `minOrder` ASC [ RunTime:0.005712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267810 ORDER BY `unit` DESC [ RunTime:0.010807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267810 LIMIT 2 [ RunTime:0.011263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267810 ORDER BY `minOrder` ASC [ RunTime:0.009959s ]
select * from pdf where partno='SA1-KI-2M-SRTC-BP50' and brandshort='Omega' limit 1 [ RunTime:0.025692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-KI-2M-SRTC-BP50' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.019463s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267810 AND `partno` = 'SA1-KI-2M-SRTC-BP50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.016080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267800 LIMIT 5 [ RunTime:0.027373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267800 ORDER BY `minOrder` ASC [ RunTime:0.021007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267800 ORDER BY `unit` DESC [ RunTime:0.043606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267800 LIMIT 2 [ RunTime:0.037369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267800 ORDER BY `minOrder` ASC [ RunTime:0.007670s ]
select * from pdf where partno='SA1-KI-3M-SRTC-BP50' and brandshort='Omega' limit 1 [ RunTime:0.029607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-KI-3M-SRTC-BP50' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.022110s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267800 AND `partno` = 'SA1-KI-3M-SRTC-BP50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.032146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267761 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267761 ORDER BY `minOrder` ASC [ RunTime:0.005718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267761 ORDER BY `unit` DESC [ RunTime:0.001902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267761 LIMIT 2 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267761 ORDER BY `minOrder` ASC [ RunTime:0.003302s ]
select * from pdf where partno='SA1-KI-1M-SMPW-M-BP50' and brandshort='Omega' limit 1 [ RunTime:0.002343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-KI-1M-SMPW-M-BP50' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.010255s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267761 AND `partno` = 'SA1-KI-1M-SMPW-M-BP50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.007622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267760 LIMIT 5 [ RunTime:0.002407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267760 ORDER BY `minOrder` ASC [ RunTime:0.006546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267760 ORDER BY `unit` DESC [ RunTime:0.004121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267760 LIMIT 2 [ RunTime:0.007867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267760 ORDER BY `minOrder` ASC [ RunTime:0.004686s ]
select * from pdf where partno='SA1-KI-1M-SRTC-BP50' and brandshort='Omega' limit 1 [ RunTime:0.015762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-KI-1M-SRTC-BP50' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002552s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267760 AND `partno` = 'SA1-KI-1M-SRTC-BP50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267758 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267758 ORDER BY `minOrder` ASC [ RunTime:0.003975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267758 ORDER BY `unit` DESC [ RunTime:0.014989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267758 LIMIT 2 [ RunTime:0.014685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267758 ORDER BY `minOrder` ASC [ RunTime:0.003267s ]
select * from pdf where partno='SA1-KI-4M-SRTC-BP50' and brandshort='Omega' limit 1 [ RunTime:0.037530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-KI-4M-SRTC-BP50' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.017213s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267758 AND `partno` = 'SA1-KI-4M-SRTC-BP50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.024142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267012 LIMIT 5 [ RunTime:0.013624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267012 ORDER BY `minOrder` ASC [ RunTime:0.030664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267012 ORDER BY `unit` DESC [ RunTime:0.027668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267012 LIMIT 2 [ RunTime:0.020912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267012 ORDER BY `minOrder` ASC [ RunTime:0.013780s ]
select * from pdf where partno='SA1-KI-10M-SC' and brandshort='Omega' limit 1 [ RunTime:0.029409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-KI-10M-SC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.042925s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267012 AND `partno` = 'SA1-KI-10M-SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.055550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266793 LIMIT 5 [ RunTime:0.023135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266793 ORDER BY `minOrder` ASC [ RunTime:0.026372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266793 ORDER BY `unit` DESC [ RunTime:0.035317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266793 LIMIT 2 [ RunTime:0.039816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266793 ORDER BY `minOrder` ASC [ RunTime:0.019809s ]
select * from pdf where partno='SA1-K-400' and brandshort='Omega' limit 1 [ RunTime:0.030144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-400' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.039029s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266793 AND `partno` = 'SA1-K-400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.052602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266428 LIMIT 5 [ RunTime:0.042256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266428 ORDER BY `minOrder` ASC [ RunTime:0.020752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266428 ORDER BY `unit` DESC [ RunTime:0.018652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266428 LIMIT 2 [ RunTime:0.072347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266428 ORDER BY `minOrder` ASC [ RunTime:0.024429s ]
select * from pdf where partno='SA1-K-240-OSTW-M' and brandshort='Omega' limit 1 [ RunTime:0.036567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-240-OSTW-M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.028522s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266428 AND `partno` = 'SA1-K-240-OSTW-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.029043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266225 LIMIT 5 [ RunTime:0.012110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266225 ORDER BY `minOrder` ASC [ RunTime:0.042632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266225 ORDER BY `unit` DESC [ RunTime:0.027798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266225 LIMIT 2 [ RunTime:0.046339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266225 ORDER BY `minOrder` ASC [ RunTime:0.021326s ]
select * from pdf where partno='SA1-KI-5M-SC' and brandshort='Omega' limit 1 [ RunTime:0.043878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-KI-5M-SC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.044432s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266225 AND `partno` = 'SA1-KI-5M-SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.027144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266197 LIMIT 5 [ RunTime:0.015861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266197 ORDER BY `minOrder` ASC [ RunTime:0.009026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266197 ORDER BY `unit` DESC [ RunTime:0.020025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266197 LIMIT 2 [ RunTime:0.013621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266197 ORDER BY `minOrder` ASC [ RunTime:0.020923s ]
select * from pdf where partno='SA1-K-200-SRTC' and brandshort='Omega' limit 1 [ RunTime:0.017673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-200-SRTC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.003236s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266197 AND `partno` = 'SA1-K-200-SRTC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.003137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266129 LIMIT 5 [ RunTime:0.005320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266129 ORDER BY `minOrder` ASC [ RunTime:0.022962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266129 ORDER BY `unit` DESC [ RunTime:0.033853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266129 LIMIT 2 [ RunTime:0.016651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266129 ORDER BY `minOrder` ASC [ RunTime:0.009848s ]
select * from pdf where partno='SA1-K-240' and brandshort='Omega' limit 1 [ RunTime:0.015083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-240' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.019798s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266129 AND `partno` = 'SA1-K-240' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.025481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266023 LIMIT 5 [ RunTime:0.029686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266023 ORDER BY `minOrder` ASC [ RunTime:0.005209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266023 ORDER BY `unit` DESC [ RunTime:0.020675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266023 LIMIT 2 [ RunTime:0.003994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266023 ORDER BY `minOrder` ASC [ RunTime:0.004625s ]
select * from pdf where partno='SA1-K-180-SRTC' and brandshort='Omega' limit 1 [ RunTime:0.024580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA1-K-180-SRTC' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.015547s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266023 AND `partno` = 'SA1-K-180-SRTC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.042464s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026825s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013583s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046619s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019194s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010236s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050310s ]
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 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011834s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SA1-K%' OR `brand` LIKE 'SA1-K%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024104s ]