SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002308s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.115' , `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=RTD-850&search=1' [ RunTime:0.001865s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002191s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001835s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003710s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.000382s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002497s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005897s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002082s ]
SELECT * FROM `stock_search` WHERE `partno` = 'RTD-850' LIMIT 1 [ RunTime:0.022358s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-14 14:37:37' WHERE `partno` = 'RTD-850' [ RunTime:0.012320s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002577s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043083s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9508 LIMIT 5 [ RunTime:0.031735s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9508 ORDER BY `minOrder` ASC [ RunTime:0.056115s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9508 ORDER BY `unit` DESC [ RunTime:0.033430s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9508 LIMIT 2 [ RunTime:0.030099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9508 ORDER BY `minOrder` ASC [ RunTime:0.009198s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-B' OR `brand` LIKE 'OMEGA%' ) ) LIMIT 1 [ RunTime:0.025148s ]
SELECT `id` FROM `stock` WHERE `id` <> 9508 AND `partno` = 'RTD-850-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.035143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322413 [ RunTime:0.069529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322413 LIMIT 5 [ RunTime:0.029512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13322413 ORDER BY `minOrder` ASC [ RunTime:0.061806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13322413 ORDER BY `unit` DESC [ RunTime:0.036647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13322413 LIMIT 2 [ RunTime:0.113736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13322413 ORDER BY `minOrder` ASC [ RunTime:0.021314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322306 LIMIT 5 [ RunTime:0.022323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13322306 ORDER BY `minOrder` ASC [ RunTime:0.109926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13322306 ORDER BY `unit` DESC [ RunTime:0.175610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13322306 LIMIT 2 [ RunTime:0.058553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13322306 ORDER BY `minOrder` ASC [ RunTime:0.014550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322205 LIMIT 5 [ RunTime:0.046034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13322205 ORDER BY `minOrder` ASC [ RunTime:0.041089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13322205 ORDER BY `unit` DESC [ RunTime:0.064261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13322205 LIMIT 2 [ RunTime:0.045571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13322205 ORDER BY `minOrder` ASC [ RunTime:0.024612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046063 LIMIT 5 [ RunTime:0.035686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046063 ORDER BY `minOrder` ASC [ RunTime:0.062787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046063 ORDER BY `unit` DESC [ RunTime:0.073540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046063 LIMIT 2 [ RunTime:0.029245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046063 ORDER BY `minOrder` ASC [ RunTime:0.019767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12045937 LIMIT 5 [ RunTime:0.020491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12045937 ORDER BY `minOrder` ASC [ RunTime:0.030665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12045937 ORDER BY `unit` DESC [ RunTime:0.027355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12045937 LIMIT 2 [ RunTime:0.047334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12045937 ORDER BY `minOrder` ASC [ RunTime:0.021760s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027452s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63293762 LIMIT 5 [ RunTime:0.016377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63293762 ORDER BY `minOrder` ASC [ RunTime:0.034434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63293762 ORDER BY `unit` DESC [ RunTime:0.030192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63293762 LIMIT 2 [ RunTime:0.046192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63293762 ORDER BY `minOrder` ASC [ RunTime:0.019977s ]
select * from pdf where partno='RTD-850-B' and brandshort='Omega' limit 1 [ RunTime:0.036039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-B' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.007799s ]
SELECT `id` FROM `stock` WHERE `id` <> 63293762 AND `partno` = 'RTD-850-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.039573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9508 [ RunTime:0.054989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322413 [ RunTime:0.023533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63296168 LIMIT 5 [ RunTime:0.005489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63296168 ORDER BY `minOrder` ASC [ RunTime:0.020591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63296168 ORDER BY `unit` DESC [ RunTime:0.024257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63296168 LIMIT 2 [ RunTime:0.034176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63296168 ORDER BY `minOrder` ASC [ RunTime:0.018273s ]
select * from pdf where partno='RTD-850-B-ROHS' and brandshort='Omega' limit 1 [ RunTime:0.034827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-B-ROHS' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.037592s ]
SELECT `id` FROM `stock` WHERE `id` <> 63296168 AND `partno` = 'RTD-850-B-ROHS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.056932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63296011 LIMIT 5 [ RunTime:0.037642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63296011 ORDER BY `minOrder` ASC [ RunTime:0.120146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63296011 ORDER BY `unit` DESC [ RunTime:0.027328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63296011 LIMIT 2 [ RunTime:0.088145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63296011 ORDER BY `minOrder` ASC [ RunTime:0.021740s ]
select * from pdf where partno='RTD-850M-5M-4-WIRE-KK-LEMO' and brandshort='Omega' limit 1 [ RunTime:0.057719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850M-5M-4-WIRE-KK-LEMO' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.054071s ]
SELECT `id` FROM `stock` WHERE `id` <> 63296011 AND `partno` = 'RTD-850M-5M-4-WIRE-KK-LEMO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.057837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295436 LIMIT 5 [ RunTime:0.064788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295436 ORDER BY `minOrder` ASC [ RunTime:0.034910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295436 ORDER BY `unit` DESC [ RunTime:0.062145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295436 LIMIT 2 [ RunTime:0.010245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295436 ORDER BY `minOrder` ASC [ RunTime:0.023804s ]
select * from pdf where partno='RTD-850-240' and brandshort='Omega' limit 1 [ RunTime:0.013080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-240' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002911s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295436 AND `partno` = 'RTD-850-240' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.000650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295361 LIMIT 5 [ RunTime:0.033218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295361 ORDER BY `minOrder` ASC [ RunTime:0.034046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295361 ORDER BY `unit` DESC [ RunTime:0.040872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295361 LIMIT 2 [ RunTime:0.024638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295361 ORDER BY `minOrder` ASC [ RunTime:0.011390s ]
select * from pdf where partno='RTD-850-144' and brandshort='Omega' limit 1 [ RunTime:0.015271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-144' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.004721s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295361 AND `partno` = 'RTD-850-144' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.015869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295224 LIMIT 5 [ RunTime:0.031215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295224 ORDER BY `minOrder` ASC [ RunTime:0.014523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295224 ORDER BY `unit` DESC [ RunTime:0.011495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295224 LIMIT 2 [ RunTime:0.030003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295224 ORDER BY `minOrder` ASC [ RunTime:0.019889s ]
select * from pdf where partno='RTD-850-TA3F-10' and brandshort='Omega' limit 1 [ RunTime:0.020786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-TA3F-10' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.076985s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295224 AND `partno` = 'RTD-850-TA3F-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.025001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295160 LIMIT 5 [ RunTime:0.016488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295160 ORDER BY `minOrder` ASC [ RunTime:0.020028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295160 ORDER BY `unit` DESC [ RunTime:0.016685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295160 LIMIT 2 [ RunTime:0.012450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295160 ORDER BY `minOrder` ASC [ RunTime:0.025049s ]
select * from pdf where partno='RTD-850-92' and brandshort='Omega' limit 1 [ RunTime:0.003085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-92' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.002277s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295160 AND `partno` = 'RTD-850-92' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.009050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295154 LIMIT 5 [ RunTime:0.034543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295154 ORDER BY `minOrder` ASC [ RunTime:0.050594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295154 ORDER BY `unit` DESC [ RunTime:0.067320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295154 LIMIT 2 [ RunTime:0.117020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295154 ORDER BY `minOrder` ASC [ RunTime:0.028056s ]
select * from pdf where partno='RTD-850M-3M' and brandshort='Omega' limit 1 [ RunTime:0.024967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850M-3M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.016972s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295154 AND `partno` = 'RTD-850M-3M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.049633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295138 LIMIT 5 [ RunTime:0.046566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295138 ORDER BY `minOrder` ASC [ RunTime:0.015549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295138 ORDER BY `unit` DESC [ RunTime:0.041971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295138 LIMIT 2 [ RunTime:0.030060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295138 ORDER BY `minOrder` ASC [ RunTime:0.010886s ]
select * from pdf where partno='RTD-850-OTP' and brandshort='Omega' limit 1 [ RunTime:0.034311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-OTP' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.024973s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295138 AND `partno` = 'RTD-850-OTP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.024589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322306 [ RunTime:0.006952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295069 LIMIT 5 [ RunTime:0.023273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295069 ORDER BY `minOrder` ASC [ RunTime:0.008077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295069 ORDER BY `unit` DESC [ RunTime:0.026112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295069 LIMIT 2 [ RunTime:0.034712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295069 ORDER BY `minOrder` ASC [ RunTime:0.011105s ]
select * from pdf where partno='RTD-850M-PT1000' and brandshort='Omega' limit 1 [ RunTime:0.011969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850M-PT1000' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.017696s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295069 AND `partno` = 'RTD-850M-PT1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.023171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295005 LIMIT 5 [ RunTime:0.025747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295005 ORDER BY `minOrder` ASC [ RunTime:0.035604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295005 ORDER BY `unit` DESC [ RunTime:0.040555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295005 LIMIT 2 [ RunTime:0.049568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295005 ORDER BY `minOrder` ASC [ RunTime:0.045833s ]
select * from pdf where partno='RTD-850M-2M' and brandshort='Omega' limit 1 [ RunTime:0.026844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850M-2M' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.056597s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295005 AND `partno` = 'RTD-850M-2M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.076347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63294986 LIMIT 5 [ RunTime:0.134794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294986 ORDER BY `minOrder` ASC [ RunTime:0.029836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63294986 ORDER BY `unit` DESC [ RunTime:0.017472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63294986 LIMIT 2 [ RunTime:0.018066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294986 ORDER BY `minOrder` ASC [ RunTime:0.038608s ]
select * from pdf where partno='RTD-850-48' and brandshort='Omega' limit 1 [ RunTime:0.056461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-48' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.058690s ]
SELECT `id` FROM `stock` WHERE `id` <> 63294986 AND `partno` = 'RTD-850-48' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.023121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63294935 LIMIT 5 [ RunTime:0.038642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294935 ORDER BY `minOrder` ASC [ RunTime:0.056545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63294935 ORDER BY `unit` DESC [ RunTime:0.036622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63294935 LIMIT 2 [ RunTime:0.033363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294935 ORDER BY `minOrder` ASC [ RunTime:0.010044s ]
select * from pdf where partno='RTD-850-ROHS' and brandshort='Omega' limit 1 [ RunTime:0.035637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-ROHS' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.036823s ]
SELECT `id` FROM `stock` WHERE `id` <> 63294935 AND `partno` = 'RTD-850-ROHS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.032371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63294794 LIMIT 5 [ RunTime:0.009744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294794 ORDER BY `minOrder` ASC [ RunTime:0.016337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63294794 ORDER BY `unit` DESC [ RunTime:0.046409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63294794 LIMIT 2 [ RunTime:0.033393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294794 ORDER BY `minOrder` ASC [ RunTime:0.009459s ]
select * from pdf where partno='RTD-850M-OTP' and brandshort='Omega' limit 1 [ RunTime:0.028901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850M-OTP' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.016566s ]
SELECT `id` FROM `stock` WHERE `id` <> 63294794 AND `partno` = 'RTD-850M-OTP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.085399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63294793 LIMIT 5 [ RunTime:0.026432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294793 ORDER BY `minOrder` ASC [ RunTime:0.044525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63294793 ORDER BY `unit` DESC [ RunTime:0.081304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63294793 LIMIT 2 [ RunTime:0.066420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294793 ORDER BY `minOrder` ASC [ RunTime:0.023653s ]
select * from pdf where partno='RTD-850M-4WIRE' and brandshort='Omega' limit 1 [ RunTime:0.026854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850M-4WIRE' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.047850s ]
SELECT `id` FROM `stock` WHERE `id` <> 63294793 AND `partno` = 'RTD-850M-4WIRE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.073496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63294631 LIMIT 5 [ RunTime:0.086776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294631 ORDER BY `minOrder` ASC [ RunTime:0.027279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63294631 ORDER BY `unit` DESC [ RunTime:0.014088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63294631 LIMIT 2 [ RunTime:0.055632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294631 ORDER BY `minOrder` ASC [ RunTime:0.012400s ]
select * from pdf where partno='RTD-850-B-120' and brandshort='Omega' limit 1 [ RunTime:0.009918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-B-120' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.031358s ]
SELECT `id` FROM `stock` WHERE `id` <> 63294631 AND `partno` = 'RTD-850-B-120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.010931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63294604 LIMIT 5 [ RunTime:0.011735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294604 ORDER BY `minOrder` ASC [ RunTime:0.026605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63294604 ORDER BY `unit` DESC [ RunTime:0.019036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63294604 LIMIT 2 [ RunTime:0.052673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294604 ORDER BY `minOrder` ASC [ RunTime:0.037902s ]
select * from pdf where partno='RTD-850-SE' and brandshort='Omega' limit 1 [ RunTime:0.051140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-SE' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.091789s ]
SELECT `id` FROM `stock` WHERE `id` <> 63294604 AND `partno` = 'RTD-850-SE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.046516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63294378 LIMIT 5 [ RunTime:0.055089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294378 ORDER BY `minOrder` ASC [ RunTime:0.081440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63294378 ORDER BY `unit` DESC [ RunTime:0.105392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63294378 LIMIT 2 [ RunTime:0.043814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63294378 ORDER BY `minOrder` ASC [ RunTime:0.061700s ]
select * from pdf where partno='RTD-850M-B' and brandshort='Omega' limit 1 [ RunTime:0.086908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850M-B' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.050858s ]
SELECT `id` FROM `stock` WHERE `id` <> 63294378 AND `partno` = 'RTD-850M-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.061782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046063 [ RunTime:0.072873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63293666 LIMIT 5 [ RunTime:0.095401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63293666 ORDER BY `minOrder` ASC [ RunTime:0.079336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63293666 ORDER BY `unit` DESC [ RunTime:0.093619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63293666 LIMIT 2 [ RunTime:0.059904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63293666 ORDER BY `minOrder` ASC [ RunTime:0.059411s ]
select * from pdf where partno='RTD-850' and brandshort='Omega' limit 1 [ RunTime:0.093116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.051292s ]
SELECT `id` FROM `stock` WHERE `id` <> 63293666 AND `partno` = 'RTD-850' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.052874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12045937 [ RunTime:0.073591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49477334 LIMIT 5 [ RunTime:0.031693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49477334 ORDER BY `minOrder` ASC [ RunTime:0.067081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49477334 ORDER BY `unit` DESC [ RunTime:0.050973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49477334 LIMIT 2 [ RunTime:0.030346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49477334 ORDER BY `minOrder` ASC [ RunTime:0.057973s ]
select * from pdf where partno='RTD-850-OTP' and brandshort='Omega' limit 1 [ RunTime:0.032918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RTD-850-OTP' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.011679s ]
SELECT `id` FROM `stock` WHERE `id` <> 49477334 AND `partno` = 'RTD-850-OTP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.048584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322306 [ RunTime:0.057687s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078827s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085072s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075686s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046533s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035122s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055346s ]
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 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047543s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RTD-850%' OR `brand` LIKE 'RTD-850%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.042613s ]