SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001113s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.113' , `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=OM-CP-HITEMP140&search=1' [ RunTime:0.005366s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000995s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002682s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.113' ) [ RunTime:0.004249s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001344s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001463s ]
SELECT * FROM `stock_search` WHERE `partno` = 'OM-CP-HITEMP140' LIMIT 1 [ RunTime:0.006493s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-06 22:48:47' WHERE `partno` = 'OM-CP-HITEMP140' [ RunTime:0.017968s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001482s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027329s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18917090 LIMIT 5 [ RunTime:0.015481s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18917090 ORDER BY `minOrder` ASC [ RunTime:0.020854s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18917090 ORDER BY `unit` DESC [ RunTime:0.035459s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18917090 LIMIT 2 [ RunTime:0.005591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18917090 ORDER BY `minOrder` ASC [ RunTime:0.001387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18917089 LIMIT 5 [ RunTime:0.019872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18917089 ORDER BY `minOrder` ASC [ RunTime:0.018355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18917089 ORDER BY `unit` DESC [ RunTime:0.010428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18917089 LIMIT 2 [ RunTime:0.010423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18917089 ORDER BY `minOrder` ASC [ RunTime:0.002190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18916231 LIMIT 5 [ RunTime:0.009626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18916231 ORDER BY `minOrder` ASC [ RunTime:0.006726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18916231 ORDER BY `unit` DESC [ RunTime:0.031612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18916231 LIMIT 2 [ RunTime:0.018732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18916231 ORDER BY `minOrder` ASC [ RunTime:0.005100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18916224 LIMIT 5 [ RunTime:0.016050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18916224 ORDER BY `minOrder` ASC [ RunTime:0.012166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18916224 ORDER BY `unit` DESC [ RunTime:0.011618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18916224 LIMIT 2 [ RunTime:0.008205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18916224 ORDER BY `minOrder` ASC [ RunTime:0.005610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850936 LIMIT 5 [ RunTime:0.030237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850936 ORDER BY `minOrder` ASC [ RunTime:0.005508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850936 ORDER BY `unit` DESC [ RunTime:0.011624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850936 LIMIT 2 [ RunTime:0.002171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850936 ORDER BY `minOrder` ASC [ RunTime:0.006377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850935 LIMIT 5 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850935 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850935 ORDER BY `unit` DESC [ RunTime:0.015980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850935 LIMIT 2 [ RunTime:0.011439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850935 ORDER BY `minOrder` ASC [ RunTime:0.001240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850926 LIMIT 5 [ RunTime:0.003208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850926 ORDER BY `minOrder` ASC [ RunTime:0.012882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850926 ORDER BY `unit` DESC [ RunTime:0.008889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850926 LIMIT 2 [ RunTime:0.016973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850926 ORDER BY `minOrder` ASC [ RunTime:0.017409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850902 LIMIT 5 [ RunTime:0.007878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850902 ORDER BY `minOrder` ASC [ RunTime:0.019423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850902 ORDER BY `unit` DESC [ RunTime:0.002439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850902 LIMIT 2 [ RunTime:0.004728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850902 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850901 LIMIT 5 [ RunTime:0.004323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850901 ORDER BY `minOrder` ASC [ RunTime:0.014763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850901 ORDER BY `unit` DESC [ RunTime:0.011601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850901 LIMIT 2 [ RunTime:0.010809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850901 ORDER BY `minOrder` ASC [ RunTime:0.007368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850897 LIMIT 5 [ RunTime:0.005990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850897 ORDER BY `minOrder` ASC [ RunTime:0.000859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850897 ORDER BY `unit` DESC [ RunTime:0.005739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850897 LIMIT 2 [ RunTime:0.009968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850897 ORDER BY `minOrder` ASC [ RunTime:0.001874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850896 LIMIT 5 [ RunTime:0.007031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850896 ORDER BY `minOrder` ASC [ RunTime:0.004912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850896 ORDER BY `unit` DESC [ RunTime:0.004581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850896 LIMIT 2 [ RunTime:0.001079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850896 ORDER BY `minOrder` ASC [ RunTime:0.004567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850895 LIMIT 5 [ RunTime:0.004021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850895 ORDER BY `minOrder` ASC [ RunTime:0.023301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850895 ORDER BY `unit` DESC [ RunTime:0.010568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850895 LIMIT 2 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850895 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800629 LIMIT 5 [ RunTime:0.018555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800629 ORDER BY `minOrder` ASC [ RunTime:0.016253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800629 ORDER BY `unit` DESC [ RunTime:0.010414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800629 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800629 ORDER BY `minOrder` ASC [ RunTime:0.015014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251543 LIMIT 5 [ RunTime:0.024695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251543 ORDER BY `minOrder` ASC [ RunTime:0.013443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15251543 ORDER BY `unit` DESC [ RunTime:0.003759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15251543 LIMIT 2 [ RunTime:0.004551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251543 ORDER BY `minOrder` ASC [ RunTime:0.018068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251351 LIMIT 5 [ RunTime:0.005087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251351 ORDER BY `minOrder` ASC [ RunTime:0.004215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15251351 ORDER BY `unit` DESC [ RunTime:0.036815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15251351 LIMIT 2 [ RunTime:0.010258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251351 ORDER BY `minOrder` ASC [ RunTime:0.013087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251350 LIMIT 5 [ RunTime:0.004455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251350 ORDER BY `minOrder` ASC [ RunTime:0.004655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15251350 ORDER BY `unit` DESC [ RunTime:0.012980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15251350 LIMIT 2 [ RunTime:0.017931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251350 ORDER BY `minOrder` ASC [ RunTime:0.013157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14192356 LIMIT 5 [ RunTime:0.011626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14192356 ORDER BY `minOrder` ASC [ RunTime:0.029674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14192356 ORDER BY `unit` DESC [ RunTime:0.024325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14192356 LIMIT 2 [ RunTime:0.010656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14192356 ORDER BY `minOrder` ASC [ RunTime:0.024080s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014562s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64580787 LIMIT 5 [ RunTime:0.008714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64580787 ORDER BY `minOrder` ASC [ RunTime:0.013313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64580787 ORDER BY `unit` DESC [ RunTime:0.015481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64580787 LIMIT 2 [ RunTime:0.012616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64580787 ORDER BY `minOrder` ASC [ RunTime:0.020909s ]
select * from pdf where partno='OM-CP-HITEMP140' and brandshort='Omega' limit 1 [ RunTime:0.037092s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.031561s ]
SELECT `id` FROM `stock` WHERE `id` <> 64580787 AND `partno` = 'OM-CP-HITEMP140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.020066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18917089 [ RunTime:0.004548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581463 LIMIT 5 [ RunTime:0.008094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581463 ORDER BY `minOrder` ASC [ RunTime:0.008947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581463 ORDER BY `unit` DESC [ RunTime:0.004320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581463 LIMIT 2 [ RunTime:0.010759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581463 ORDER BY `minOrder` ASC [ RunTime:0.053870s ]
select * from pdf where partno='OM-CP-HITEMP140-TSK' and brandshort='Omega' limit 1 [ RunTime:0.021410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-TSK' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.013101s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581463 AND `partno` = 'OM-CP-HITEMP140-TSK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.045100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14192356 [ RunTime:0.028485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581460 LIMIT 5 [ RunTime:0.004131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581460 ORDER BY `minOrder` ASC [ RunTime:0.008909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581460 ORDER BY `unit` DESC [ RunTime:0.013798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581460 LIMIT 2 [ RunTime:0.008429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581460 ORDER BY `minOrder` ASC [ RunTime:0.007050s ]
select * from pdf where partno='OM-CP-HITEMP140-1' and brandshort='Omega' limit 1 [ RunTime:0.005794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.005101s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581460 AND `partno` = 'OM-CP-HITEMP140-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.040199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18917090 [ RunTime:0.031433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581888 LIMIT 5 [ RunTime:0.011403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581888 ORDER BY `minOrder` ASC [ RunTime:0.020614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581888 ORDER BY `unit` DESC [ RunTime:0.036067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581888 LIMIT 2 [ RunTime:0.030263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581888 ORDER BY `minOrder` ASC [ RunTime:0.008502s ]
select * from pdf where partno='OM-CP-HITEMP140X2-TD-PT-5' and brandshort='Omega' limit 1 [ RunTime:0.005083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140X2-TD-PT-5' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.007338s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581888 AND `partno` = 'OM-CP-HITEMP140X2-TD-PT-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.022940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581887 LIMIT 5 [ RunTime:0.020726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581887 ORDER BY `minOrder` ASC [ RunTime:0.011579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581887 ORDER BY `unit` DESC [ RunTime:0.030480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581887 LIMIT 2 [ RunTime:0.014769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581887 ORDER BY `minOrder` ASC [ RunTime:0.024779s ]
select * from pdf where partno='OM-CP-HITEMP140X2-TD-FP-72' and brandshort='Omega' limit 1 [ RunTime:0.024142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140X2-TD-FP-72' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.030837s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581887 AND `partno` = 'OM-CP-HITEMP140X2-TD-FP-72' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.025220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251350 [ RunTime:0.021158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581886 LIMIT 5 [ RunTime:0.016595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581886 ORDER BY `minOrder` ASC [ RunTime:0.029804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581886 ORDER BY `unit` DESC [ RunTime:0.030373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581886 LIMIT 2 [ RunTime:0.019439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581886 ORDER BY `minOrder` ASC [ RunTime:0.004708s ]
select * from pdf where partno='OM-CP-HITEMP140X2-TD-PT-1' and brandshort='Omega' limit 1 [ RunTime:0.021811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140X2-TD-PT-1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.038537s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581886 AND `partno` = 'OM-CP-HITEMP140X2-TD-PT-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.026706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18916231 [ RunTime:0.017450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581882 LIMIT 5 [ RunTime:0.045385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581882 ORDER BY `minOrder` ASC [ RunTime:0.006506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581882 ORDER BY `unit` DESC [ RunTime:0.035237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581882 LIMIT 2 [ RunTime:0.029952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581882 ORDER BY `minOrder` ASC [ RunTime:0.001301s ]
select * from pdf where partno='OM-CP-HITEMP140X2-FP-72-PT-5' and brandshort='Omega' limit 1 [ RunTime:0.018358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140X2-FP-72-PT-5' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.043411s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581882 AND `partno` = 'OM-CP-HITEMP140X2-FP-72-PT-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.017138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581881 LIMIT 5 [ RunTime:0.027871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581881 ORDER BY `minOrder` ASC [ RunTime:0.013564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581881 ORDER BY `unit` DESC [ RunTime:0.016241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581881 LIMIT 2 [ RunTime:0.018527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581881 ORDER BY `minOrder` ASC [ RunTime:0.015898s ]
select * from pdf where partno='OM-CP-HITEMP140X2-FP-72-PT-1' and brandshort='Omega' limit 1 [ RunTime:0.068116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140X2-FP-72-PT-1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.021475s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581881 AND `partno` = 'OM-CP-HITEMP140X2-FP-72-PT-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.018716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251351 [ RunTime:0.033470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581875 LIMIT 5 [ RunTime:0.020065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581875 ORDER BY `minOrder` ASC [ RunTime:0.047450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581875 ORDER BY `unit` DESC [ RunTime:0.037121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581875 LIMIT 2 [ RunTime:0.057491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581875 ORDER BY `minOrder` ASC [ RunTime:0.007310s ]
select * from pdf where partno='OM-CP-HITEMP140X2-FP-72' and brandshort='Omega' limit 1 [ RunTime:0.035862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140X2-FP-72' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.023836s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581875 AND `partno` = 'OM-CP-HITEMP140X2-FP-72' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.011882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18916224 [ RunTime:0.033456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64581811 LIMIT 5 [ RunTime:0.014243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581811 ORDER BY `minOrder` ASC [ RunTime:0.067685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64581811 ORDER BY `unit` DESC [ RunTime:0.013362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64581811 LIMIT 2 [ RunTime:0.013864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64581811 ORDER BY `minOrder` ASC [ RunTime:0.009917s ]
select * from pdf where partno='OM-CP-HITEMP140-5.25' and brandshort='Omega' limit 1 [ RunTime:0.014518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-5.25' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.042314s ]
SELECT `id` FROM `stock` WHERE `id` <> 64581811 AND `partno` = 'OM-CP-HITEMP140-5.25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.024086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251543 [ RunTime:0.025228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63523101 LIMIT 5 [ RunTime:0.020035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523101 ORDER BY `minOrder` ASC [ RunTime:0.095882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63523101 ORDER BY `unit` DESC [ RunTime:0.034537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63523101 LIMIT 2 [ RunTime:0.030339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523101 ORDER BY `minOrder` ASC [ RunTime:0.005363s ]
select * from pdf where partno='OM-CP-HITEMP140-M12' and brandshort='Omega' limit 1 [ RunTime:0.025918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-M12' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.065478s ]
SELECT `id` FROM `stock` WHERE `id` <> 63523101 AND `partno` = 'OM-CP-HITEMP140-M12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.041902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800629 [ RunTime:0.023735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63523002 LIMIT 5 [ RunTime:0.022664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523002 ORDER BY `minOrder` ASC [ RunTime:0.044433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63523002 ORDER BY `unit` DESC [ RunTime:0.024544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63523002 LIMIT 2 [ RunTime:0.037413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523002 ORDER BY `minOrder` ASC [ RunTime:0.026798s ]
select * from pdf where partno='OM-CP-HITEMP140-7-TSK' and brandshort='Omega' limit 1 [ RunTime:0.016069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-7-TSK' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.030470s ]
SELECT `id` FROM `stock` WHERE `id` <> 63523002 AND `partno` = 'OM-CP-HITEMP140-7-TSK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.005229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522994 LIMIT 5 [ RunTime:0.000776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522994 ORDER BY `minOrder` ASC [ RunTime:0.022416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522994 ORDER BY `unit` DESC [ RunTime:0.019721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522994 LIMIT 2 [ RunTime:0.030864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522994 ORDER BY `minOrder` ASC [ RunTime:0.010436s ]
select * from pdf where partno='OM-CP-HITEMP140-PT-5-TSK' and brandshort='Omega' limit 1 [ RunTime:0.009522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-PT-5-TSK' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.011459s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522994 AND `partno` = 'OM-CP-HITEMP140-PT-5-TSK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.015683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850936 [ RunTime:0.007550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522993 LIMIT 5 [ RunTime:0.018029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522993 ORDER BY `minOrder` ASC [ RunTime:0.018207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522993 ORDER BY `unit` DESC [ RunTime:0.010299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522993 LIMIT 2 [ RunTime:0.006264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522993 ORDER BY `minOrder` ASC [ RunTime:0.014145s ]
select * from pdf where partno='OM-CP-HITEMP140-PT-1-TSK' and brandshort='Omega' limit 1 [ RunTime:0.004394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-PT-1-TSK' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.018947s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522993 AND `partno` = 'OM-CP-HITEMP140-PT-1-TSK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.006445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850935 [ RunTime:0.000791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522991 LIMIT 5 [ RunTime:0.006253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522991 ORDER BY `minOrder` ASC [ RunTime:0.007185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522991 ORDER BY `unit` DESC [ RunTime:0.015868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522991 LIMIT 2 [ RunTime:0.020448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522991 ORDER BY `minOrder` ASC [ RunTime:0.015410s ]
select * from pdf where partno='OM-CP-HITEMP140-FP-72-TSK-FL' and brandshort='Omega' limit 1 [ RunTime:0.003483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-FP-72-TSK-FL' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.006448s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522991 AND `partno` = 'OM-CP-HITEMP140-FP-72-TSK-FL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.014061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522990 LIMIT 5 [ RunTime:0.012133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522990 ORDER BY `minOrder` ASC [ RunTime:0.020746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522990 ORDER BY `unit` DESC [ RunTime:0.013877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522990 LIMIT 2 [ RunTime:0.008914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522990 ORDER BY `minOrder` ASC [ RunTime:0.006307s ]
select * from pdf where partno='OM-CP-HITEMP140-FP-36-TSK' and brandshort='Omega' limit 1 [ RunTime:0.003498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-FP-36-TSK' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002203s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522990 AND `partno` = 'OM-CP-HITEMP140-FP-36-TSK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.011964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850926 [ RunTime:0.023721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522972 LIMIT 5 [ RunTime:0.008924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522972 ORDER BY `minOrder` ASC [ RunTime:0.011880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522972 ORDER BY `unit` DESC [ RunTime:0.011144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522972 LIMIT 2 [ RunTime:0.022301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522972 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
select * from pdf where partno='OM-CP-HITEMP140-PT-5' and brandshort='Omega' limit 1 [ RunTime:0.015041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-PT-5' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.010490s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522972 AND `partno` = 'OM-CP-HITEMP140-PT-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.014521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850902 [ RunTime:0.013002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522971 LIMIT 5 [ RunTime:0.010856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522971 ORDER BY `minOrder` ASC [ RunTime:0.042817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522971 ORDER BY `unit` DESC [ RunTime:0.071903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522971 LIMIT 2 [ RunTime:0.016240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522971 ORDER BY `minOrder` ASC [ RunTime:0.026948s ]
select * from pdf where partno='OM-CP-HITEMP140-PT-1' and brandshort='Omega' limit 1 [ RunTime:0.026341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-PT-1' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.020091s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522971 AND `partno` = 'OM-CP-HITEMP140-PT-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.027418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850901 [ RunTime:0.027243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522970 LIMIT 5 [ RunTime:0.020451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522970 ORDER BY `minOrder` ASC [ RunTime:0.030512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522970 ORDER BY `unit` DESC [ RunTime:0.028775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522970 LIMIT 2 [ RunTime:0.022400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522970 ORDER BY `minOrder` ASC [ RunTime:0.016145s ]
select * from pdf where partno='OM-CP-HITEMP140-FP-36' and brandshort='Omega' limit 1 [ RunTime:0.006414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-FP-36' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.023426s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522970 AND `partno` = 'OM-CP-HITEMP140-FP-36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.045471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850897 [ RunTime:0.015822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522969 LIMIT 5 [ RunTime:0.048792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522969 ORDER BY `minOrder` ASC [ RunTime:0.033771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522969 ORDER BY `unit` DESC [ RunTime:0.014745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522969 LIMIT 2 [ RunTime:0.010288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522969 ORDER BY `minOrder` ASC [ RunTime:0.017372s ]
select * from pdf where partno='OM-CP-HITEMP140-FP-72' and brandshort='Omega' limit 1 [ RunTime:0.070981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OM-CP-HITEMP140-FP-72' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.003202s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522969 AND `partno` = 'OM-CP-HITEMP140-FP-72' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.034601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850896 [ RunTime:0.040259s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017252s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013971s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019737s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032498s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067694s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016586s ]
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 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051211s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'OM-CP-HITEMP140%' OR `brand` LIKE 'OM-CP-HITEMP140%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030427s ]