SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002809s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=OPV314&search=1' [ RunTime:0.001923s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001984s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002706s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000404s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002759s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002235s ]
SELECT * FROM `stock_search` WHERE `partno` = 'OPV314' LIMIT 1 [ RunTime:0.007752s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-22 17:40:36' WHERE `partno` = 'OPV314' [ RunTime:0.002973s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002632s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011068s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11228381 LIMIT 5 [ RunTime:0.012699s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228381 ORDER BY `minOrder` ASC [ RunTime:0.001579s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11228381 ORDER BY `unit` DESC [ RunTime:0.003918s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11228381 LIMIT 2 [ RunTime:0.016797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228381 ORDER BY `minOrder` ASC [ RunTime:0.024320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12229015 LIMIT 5 [ RunTime:0.005795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12229015 ORDER BY `minOrder` ASC [ RunTime:0.000711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12229015 ORDER BY `unit` DESC [ RunTime:0.025764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12229015 LIMIT 2 [ RunTime:0.013395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12229015 ORDER BY `minOrder` ASC [ RunTime:0.007297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11228415 LIMIT 5 [ RunTime:0.027098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228415 ORDER BY `minOrder` ASC [ RunTime:0.003992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11228415 ORDER BY `unit` DESC [ RunTime:0.034350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11228415 LIMIT 2 [ RunTime:0.026380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228415 ORDER BY `minOrder` ASC [ RunTime:0.036033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12229016 LIMIT 5 [ RunTime:0.017209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12229016 ORDER BY `minOrder` ASC [ RunTime:0.022741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12229016 ORDER BY `unit` DESC [ RunTime:0.018407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12229016 LIMIT 2 [ RunTime:0.012882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12229016 ORDER BY `minOrder` ASC [ RunTime:0.025358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12229193 LIMIT 5 [ RunTime:0.012389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12229193 ORDER BY `minOrder` ASC [ RunTime:0.013490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12229193 ORDER BY `unit` DESC [ RunTime:0.045870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12229193 LIMIT 2 [ RunTime:0.032350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12229193 ORDER BY `minOrder` ASC [ RunTime:0.001552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11228518 LIMIT 5 [ RunTime:0.020323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228518 ORDER BY `minOrder` ASC [ RunTime:0.020520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11228518 ORDER BY `unit` DESC [ RunTime:0.007021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11228518 LIMIT 2 [ RunTime:0.003044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228518 ORDER BY `minOrder` ASC [ RunTime:0.002310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11228517 LIMIT 5 [ RunTime:0.016525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228517 ORDER BY `minOrder` ASC [ RunTime:0.013100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11228517 ORDER BY `unit` DESC [ RunTime:0.024639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11228517 LIMIT 2 [ RunTime:0.019366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228517 ORDER BY `minOrder` ASC [ RunTime:0.004818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11228469 LIMIT 5 [ RunTime:0.008833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228469 ORDER BY `minOrder` ASC [ RunTime:0.001058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11228469 ORDER BY `unit` DESC [ RunTime:0.012340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11228469 LIMIT 2 [ RunTime:0.018043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11228469 ORDER BY `minOrder` ASC [ RunTime:0.019676s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237565 LIMIT 5 [ RunTime:0.005800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237565 ORDER BY `minOrder` ASC [ RunTime:0.025347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237565 ORDER BY `unit` DESC [ RunTime:0.036486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237565 LIMIT 2 [ RunTime:0.014542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237565 ORDER BY `minOrder` ASC [ RunTime:0.002663s ]
select * from pdf where partno='opv314' and brandshort='optek / tt electronics' limit 1 [ RunTime:0.016296s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'opv314' OR `brand` LIKE 'optek / tt electronics%' ) ) LIMIT 1 [ RunTime:0.019156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237621 LIMIT 5 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237621 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237621 ORDER BY `unit` DESC [ RunTime:0.016086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237621 LIMIT 2 [ RunTime:0.019336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237621 ORDER BY `minOrder` ASC [ RunTime:0.017935s ]
select * from pdf where partno='opv314y' and brandshort='optek / tt electronics' limit 1 [ RunTime:0.028455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'opv314y' OR `brand` LIKE 'optek / tt electronics%' ) ) LIMIT 1 [ RunTime:0.014347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237635 LIMIT 5 [ RunTime:0.008652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237635 ORDER BY `minOrder` ASC [ RunTime:0.010822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237635 ORDER BY `unit` DESC [ RunTime:0.000911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237635 LIMIT 2 [ RunTime:0.001956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237635 ORDER BY `minOrder` ASC [ RunTime:0.006258s ]
select * from pdf where partno='opv314at' and brandshort='optek / tt electronics' limit 1 [ RunTime:0.006446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'opv314at' OR `brand` LIKE 'optek / tt electronics%' ) ) LIMIT 1 [ RunTime:0.009736s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237635 AND `partno` = 'opv314at' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%optek / tt electronics%' ) [ RunTime:0.002388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237564 LIMIT 5 [ RunTime:0.003163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237564 ORDER BY `minOrder` ASC [ RunTime:0.005403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237564 ORDER BY `unit` DESC [ RunTime:0.002415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237564 LIMIT 2 [ RunTime:0.002565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237564 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='opv314ybt' and brandshort='optek / tt electronics' limit 1 [ RunTime:0.002662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'opv314ybt' OR `brand` LIKE 'optek / tt electronics%' ) ) LIMIT 1 [ RunTime:0.006874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237625 LIMIT 5 [ RunTime:0.004400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237625 ORDER BY `minOrder` ASC [ RunTime:0.001072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237625 ORDER BY `unit` DESC [ RunTime:0.008890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237625 LIMIT 2 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237625 ORDER BY `minOrder` ASC [ RunTime:0.001572s ]
select * from pdf where partno='opv314yat' and brandshort='optek / tt electronics' limit 1 [ RunTime:0.001484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'opv314yat' OR `brand` LIKE 'optek / tt electronics%' ) ) LIMIT 1 [ RunTime:0.001807s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58114314 LIMIT 5 [ RunTime:0.006284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114314 ORDER BY `minOrder` ASC [ RunTime:0.012080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58114314 ORDER BY `unit` DESC [ RunTime:0.005725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58114314 LIMIT 2 [ RunTime:0.008281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114314 ORDER BY `minOrder` ASC [ RunTime:0.002973s ]
select * from pdf where partno='OPV314YAT' and brandshort='TT Electronics/Optek Technology' limit 1 [ RunTime:0.001079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OPV314YAT' OR `brand` LIKE 'TT Electronics/Optek Technology%' ) ) LIMIT 1 [ RunTime:0.005681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58114343 LIMIT 5 [ RunTime:0.007991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114343 ORDER BY `minOrder` ASC [ RunTime:0.008758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58114343 ORDER BY `unit` DESC [ RunTime:0.000838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58114343 LIMIT 2 [ RunTime:0.002433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114343 ORDER BY `minOrder` ASC [ RunTime:0.004587s ]
select * from pdf where partno='OPV314Y' and brandshort='TT Electronics/Optek Technology' limit 1 [ RunTime:0.003401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OPV314Y' OR `brand` LIKE 'TT Electronics/Optek Technology%' ) ) LIMIT 1 [ RunTime:0.009848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58114861 LIMIT 5 [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114861 ORDER BY `minOrder` ASC [ RunTime:0.014201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58114861 ORDER BY `unit` DESC [ RunTime:0.004109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58114861 LIMIT 2 [ RunTime:0.005954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114861 ORDER BY `minOrder` ASC [ RunTime:0.003786s ]
select * from pdf where partno='OPV314YF' and brandshort='TT Electronics/Optek Technology' limit 1 [ RunTime:0.001570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OPV314YF' OR `brand` LIKE 'TT Electronics/Optek Technology%' ) ) LIMIT 1 [ RunTime:0.003595s ]
SELECT `id` FROM `stock` WHERE `id` <> 58114861 AND `partno` = 'OPV314YF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/optek technology%' ) [ RunTime:0.007106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11228518 [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58114860 LIMIT 5 [ RunTime:0.010225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114860 ORDER BY `minOrder` ASC [ RunTime:0.003647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58114860 ORDER BY `unit` DESC [ RunTime:0.011336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58114860 LIMIT 2 [ RunTime:0.033276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114860 ORDER BY `minOrder` ASC [ RunTime:0.003103s ]
select * from pdf where partno='OPV314F' and brandshort='TT Electronics/Optek Technology' limit 1 [ RunTime:0.005836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OPV314F' OR `brand` LIKE 'TT Electronics/Optek Technology%' ) ) LIMIT 1 [ RunTime:0.009714s ]
SELECT `id` FROM `stock` WHERE `id` <> 58114860 AND `partno` = 'OPV314F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/optek technology%' ) [ RunTime:0.021311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11228517 [ RunTime:0.001014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58114850 LIMIT 5 [ RunTime:0.002370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114850 ORDER BY `minOrder` ASC [ RunTime:0.019456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58114850 ORDER BY `unit` DESC [ RunTime:0.003275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58114850 LIMIT 2 [ RunTime:0.020183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114850 ORDER BY `minOrder` ASC [ RunTime:0.014814s ]
select * from pdf where partno='OPV314BT' and brandshort='TT Electronics/Optek Technology' limit 1 [ RunTime:0.017002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OPV314BT' OR `brand` LIKE 'TT Electronics/Optek Technology%' ) ) LIMIT 1 [ RunTime:0.011009s ]
SELECT `id` FROM `stock` WHERE `id` <> 58114850 AND `partno` = 'OPV314BT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/optek technology%' ) [ RunTime:0.018808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12229193 [ RunTime:0.025312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58114611 LIMIT 5 [ RunTime:0.026209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114611 ORDER BY `minOrder` ASC [ RunTime:0.024008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58114611 ORDER BY `unit` DESC [ RunTime:0.038599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58114611 LIMIT 2 [ RunTime:0.023181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114611 ORDER BY `minOrder` ASC [ RunTime:0.006180s ]
select * from pdf where partno='OPV314YBT' and brandshort='TT Electronics/Optek Technology' limit 1 [ RunTime:0.038938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OPV314YBT' OR `brand` LIKE 'TT Electronics/Optek Technology%' ) ) LIMIT 1 [ RunTime:0.039398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58114541 LIMIT 5 [ RunTime:0.035608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114541 ORDER BY `minOrder` ASC [ RunTime:0.023153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58114541 ORDER BY `unit` DESC [ RunTime:0.030741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58114541 LIMIT 2 [ RunTime:0.013734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114541 ORDER BY `minOrder` ASC [ RunTime:0.009143s ]
select * from pdf where partno='OPV314' and brandshort='TT Electronics/Optek Technology' limit 1 [ RunTime:0.012637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OPV314' OR `brand` LIKE 'TT Electronics/Optek Technology%' ) ) LIMIT 1 [ RunTime:0.048245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58114539 LIMIT 5 [ RunTime:0.072380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114539 ORDER BY `minOrder` ASC [ RunTime:0.018793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58114539 ORDER BY `unit` DESC [ RunTime:0.045925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58114539 LIMIT 2 [ RunTime:0.104004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58114539 ORDER BY `minOrder` ASC [ RunTime:0.047103s ]
select * from pdf where partno='OPV314AT' and brandshort='TT Electronics/Optek Technology' limit 1 [ RunTime:0.034026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OPV314AT' OR `brand` LIKE 'TT Electronics/Optek Technology%' ) ) LIMIT 1 [ RunTime:0.038580s ]
SELECT `id` FROM `stock` WHERE `id` <> 58114539 AND `partno` = 'OPV314AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/optek technology%' ) [ RunTime:0.133815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11228415 [ RunTime:0.128816s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.096424s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.084467s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.115149s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.148237s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.182475s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065969s ]
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 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.107851s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'OPV314%' OR `brand` LIKE 'OPV314%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022522s ]