SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001393s ]
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=AFPH&search=1' [ RunTime:0.009307s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002130s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000496s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002538s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002937s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002270s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000341s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003064s ]
SELECT * FROM `stock_search` WHERE `partno` = 'AFPH' LIMIT 1 [ RunTime:0.001664s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-28 16:53:12' WHERE `partno` = 'AFPH' [ RunTime:0.003066s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002157s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007786s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18999106 LIMIT 5 [ RunTime:0.000879s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18999106 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18999106 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18999106 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18999106 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998997 LIMIT 5 [ RunTime:0.002527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998997 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998997 ORDER BY `unit` DESC [ RunTime:0.000973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998997 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998997 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998955 LIMIT 5 [ RunTime:0.003232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998955 ORDER BY `minOrder` ASC [ RunTime:0.001023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998955 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998955 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998955 ORDER BY `minOrder` ASC [ RunTime:0.001846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998904 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998904 ORDER BY `minOrder` ASC [ RunTime:0.007176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998904 ORDER BY `unit` DESC [ RunTime:0.004179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998904 LIMIT 2 [ RunTime:0.019990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998904 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998880 LIMIT 5 [ RunTime:0.006799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998880 ORDER BY `minOrder` ASC [ RunTime:0.009128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998880 ORDER BY `unit` DESC [ RunTime:0.008035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998880 LIMIT 2 [ RunTime:0.006711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998880 ORDER BY `minOrder` ASC [ RunTime:0.000901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998749 LIMIT 5 [ RunTime:0.001042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998749 ORDER BY `minOrder` ASC [ RunTime:0.025044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998749 ORDER BY `unit` DESC [ RunTime:0.038513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998749 LIMIT 2 [ RunTime:0.013837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998749 ORDER BY `minOrder` ASC [ RunTime:0.007480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998722 LIMIT 5 [ RunTime:0.002836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998722 ORDER BY `minOrder` ASC [ RunTime:0.000711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998722 ORDER BY `unit` DESC [ RunTime:0.009136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998722 LIMIT 2 [ RunTime:0.007042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998722 ORDER BY `minOrder` ASC [ RunTime:0.011933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998429 LIMIT 5 [ RunTime:0.005213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998429 ORDER BY `minOrder` ASC [ RunTime:0.006637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998429 ORDER BY `unit` DESC [ RunTime:0.019282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998429 LIMIT 2 [ RunTime:0.002656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998429 ORDER BY `minOrder` ASC [ RunTime:0.004188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18993472 LIMIT 5 [ RunTime:0.010539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18993472 ORDER BY `minOrder` ASC [ RunTime:0.004245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18993472 ORDER BY `unit` DESC [ RunTime:0.002192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18993472 LIMIT 2 [ RunTime:0.008019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18993472 ORDER BY `minOrder` ASC [ RunTime:0.010072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17052906 LIMIT 5 [ RunTime:0.008797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17052906 ORDER BY `minOrder` ASC [ RunTime:0.016854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17052906 ORDER BY `unit` DESC [ RunTime:0.001341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17052906 LIMIT 2 [ RunTime:0.005073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17052906 ORDER BY `minOrder` ASC [ RunTime:0.003282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17052839 LIMIT 5 [ RunTime:0.006660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17052839 ORDER BY `minOrder` ASC [ RunTime:0.001061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17052839 ORDER BY `unit` DESC [ RunTime:0.002753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17052839 LIMIT 2 [ RunTime:0.001760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17052839 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15269969 LIMIT 5 [ RunTime:0.002395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15269969 ORDER BY `minOrder` ASC [ RunTime:0.005832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15269969 ORDER BY `unit` DESC [ RunTime:0.001122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15269969 LIMIT 2 [ RunTime:0.003993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15269969 ORDER BY `minOrder` ASC [ RunTime:0.003153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15269944 LIMIT 5 [ RunTime:0.002301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15269944 ORDER BY `minOrder` ASC [ RunTime:0.001048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15269944 ORDER BY `unit` DESC [ RunTime:0.008194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15269944 LIMIT 2 [ RunTime:0.004654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15269944 ORDER BY `minOrder` ASC [ RunTime:0.011305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199741 LIMIT 5 [ RunTime:0.006095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199741 ORDER BY `minOrder` ASC [ RunTime:0.007110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14199741 ORDER BY `unit` DESC [ RunTime:0.004698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14199741 LIMIT 2 [ RunTime:0.003132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199741 ORDER BY `minOrder` ASC [ RunTime:0.018686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199698 LIMIT 5 [ RunTime:0.016236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199698 ORDER BY `minOrder` ASC [ RunTime:0.028541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14199698 ORDER BY `unit` DESC [ RunTime:0.010326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14199698 LIMIT 2 [ RunTime:0.009519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199698 ORDER BY `minOrder` ASC [ RunTime:0.006270s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017980s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463986 LIMIT 5 [ RunTime:0.021880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463986 ORDER BY `minOrder` ASC [ RunTime:0.018337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463986 ORDER BY `unit` DESC [ RunTime:0.009864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463986 LIMIT 2 [ RunTime:0.014519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463986 ORDER BY `minOrder` ASC [ RunTime:0.013525s ]
select * from pdf where partno='AFPH4032A-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.011407s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH4032A-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.010091s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463986 AND `partno` = 'AFPH4032A-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.015336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18999106 [ RunTime:0.022535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463945 LIMIT 5 [ RunTime:0.023645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463945 ORDER BY `minOrder` ASC [ RunTime:0.048464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463945 ORDER BY `unit` DESC [ RunTime:0.018818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463945 LIMIT 2 [ RunTime:0.009041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463945 ORDER BY `minOrder` ASC [ RunTime:0.001023s ]
select * from pdf where partno='AFPH4032N-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.010076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH4032N-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.043597s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463945 AND `partno` = 'AFPH4032N-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.024834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199741 [ RunTime:0.039010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463878 LIMIT 5 [ RunTime:0.031797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463878 ORDER BY `minOrder` ASC [ RunTime:0.015988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463878 ORDER BY `unit` DESC [ RunTime:0.005995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463878 LIMIT 2 [ RunTime:0.016746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463878 ORDER BY `minOrder` ASC [ RunTime:0.010413s ]
select * from pdf where partno='AFPH3325N-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.041920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH3325N-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.032954s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463878 AND `partno` = 'AFPH3325N-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.045152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17052906 [ RunTime:0.012708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463848 LIMIT 5 [ RunTime:0.013406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463848 ORDER BY `minOrder` ASC [ RunTime:0.002381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463848 ORDER BY `unit` DESC [ RunTime:0.101781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463848 LIMIT 2 [ RunTime:0.042132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463848 ORDER BY `minOrder` ASC [ RunTime:0.076758s ]
select * from pdf where partno='AFPH3325A-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.016661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH3325A-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.074718s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463848 AND `partno` = 'AFPH3325A-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.056496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998997 [ RunTime:0.053974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463774 LIMIT 5 [ RunTime:0.132421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463774 ORDER BY `minOrder` ASC [ RunTime:0.039461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463774 ORDER BY `unit` DESC [ RunTime:0.057245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463774 LIMIT 2 [ RunTime:0.035172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463774 ORDER BY `minOrder` ASC [ RunTime:0.003357s ]
select * from pdf where partno='AFPH2820A-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.014527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH2820A-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.011447s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463774 AND `partno` = 'AFPH2820A-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.010014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998955 [ RunTime:0.013710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463699 LIMIT 5 [ RunTime:0.012461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463699 ORDER BY `minOrder` ASC [ RunTime:0.005866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463699 ORDER BY `unit` DESC [ RunTime:0.008474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463699 LIMIT 2 [ RunTime:0.012909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463699 ORDER BY `minOrder` ASC [ RunTime:0.001186s ]
select * from pdf where partno='AFPH2416A-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.010641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH2416A-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.008558s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463699 AND `partno` = 'AFPH2416A-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.011889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998904 [ RunTime:0.010017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463666 LIMIT 5 [ RunTime:0.006054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463666 ORDER BY `minOrder` ASC [ RunTime:0.013069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463666 ORDER BY `unit` DESC [ RunTime:0.014826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463666 LIMIT 2 [ RunTime:0.009004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463666 ORDER BY `minOrder` ASC [ RunTime:0.004458s ]
select * from pdf where partno='AFPH2016A-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.011040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH2016A-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.008324s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463666 AND `partno` = 'AFPH2016A-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.001945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998880 [ RunTime:0.001201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463662 LIMIT 5 [ RunTime:0.004790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463662 ORDER BY `minOrder` ASC [ RunTime:0.008471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463662 ORDER BY `unit` DESC [ RunTime:0.011541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463662 LIMIT 2 [ RunTime:0.013382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463662 ORDER BY `minOrder` ASC [ RunTime:0.007644s ]
select * from pdf where partno='AFPH2820N-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.014872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH2820N-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.013401s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463662 AND `partno` = 'AFPH2820N-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.018351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15269969 [ RunTime:0.016240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463577 LIMIT 5 [ RunTime:0.010484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463577 ORDER BY `minOrder` ASC [ RunTime:0.017627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463577 ORDER BY `unit` DESC [ RunTime:0.011589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463577 LIMIT 2 [ RunTime:0.009517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463577 ORDER BY `minOrder` ASC [ RunTime:0.001872s ]
select * from pdf where partno='AFPH1612A-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.010257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH1612A-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.001793s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463577 AND `partno` = 'AFPH1612A-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.009737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998749 [ RunTime:0.012432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463527 LIMIT 5 [ RunTime:0.005402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463527 ORDER BY `minOrder` ASC [ RunTime:0.000804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463527 ORDER BY `unit` DESC [ RunTime:0.006321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463527 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463527 ORDER BY `minOrder` ASC [ RunTime:0.008264s ]
select * from pdf where partno='AFPH2016N-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.001298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH2016N-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.013737s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463527 AND `partno` = 'AFPH2016N-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.007447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15269944 [ RunTime:0.004184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463520 LIMIT 5 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463520 ORDER BY `minOrder` ASC [ RunTime:0.002213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463520 ORDER BY `unit` DESC [ RunTime:0.005102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463520 LIMIT 2 [ RunTime:0.004617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463520 ORDER BY `minOrder` ASC [ RunTime:0.002541s ]
select * from pdf where partno='AFPH1208A-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.006719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH1208A-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.002960s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463520 AND `partno` = 'AFPH1208A-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.001883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998722 [ RunTime:0.005234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463458 LIMIT 5 [ RunTime:0.002598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463458 ORDER BY `minOrder` ASC [ RunTime:0.002183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463458 ORDER BY `unit` DESC [ RunTime:0.002896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463458 LIMIT 2 [ RunTime:0.004856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463458 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
select * from pdf where partno='AFPH2416N-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH2416N-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.005089s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463458 AND `partno` = 'AFPH2416N-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.001153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199698 [ RunTime:0.015935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463325 LIMIT 5 [ RunTime:0.004261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463325 ORDER BY `minOrder` ASC [ RunTime:0.014058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463325 ORDER BY `unit` DESC [ RunTime:0.006675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463325 LIMIT 2 [ RunTime:0.009347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463325 ORDER BY `minOrder` ASC [ RunTime:0.008479s ]
select * from pdf where partno='AFPH1612N-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.003166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH1612N-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.011355s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463325 AND `partno` = 'AFPH1612N-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17052839 [ RunTime:0.009037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63463014 LIMIT 5 [ RunTime:0.001566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463014 ORDER BY `minOrder` ASC [ RunTime:0.012981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63463014 ORDER BY `unit` DESC [ RunTime:0.000857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63463014 LIMIT 2 [ RunTime:0.009864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63463014 ORDER BY `minOrder` ASC [ RunTime:0.001648s ]
select * from pdf where partno='AFPH1208N-KIT' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.001355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH1208N-KIT' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.008287s ]
SELECT `id` FROM `stock` WHERE `id` <> 63463014 AND `partno` = 'AFPH1208N-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.003925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998429 [ RunTime:0.000576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63455788 LIMIT 5 [ RunTime:0.025214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63455788 ORDER BY `minOrder` ASC [ RunTime:0.006999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63455788 ORDER BY `unit` DESC [ RunTime:0.015210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63455788 LIMIT 2 [ RunTime:0.008254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63455788 ORDER BY `minOrder` ASC [ RunTime:0.003322s ]
select * from pdf where partno='AFPH' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.011420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFPH' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.007183s ]
SELECT `id` FROM `stock` WHERE `id` <> 63455788 AND `partno` = 'AFPH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.002718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18993472 [ RunTime:0.011214s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004748s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012799s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008673s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007290s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023129s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010490s ]
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 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019197s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'AFPH%' OR `brand` LIKE 'AFPH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013522s ]