SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001791s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=ANM5&search=1' [ RunTime:0.022006s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002158s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000411s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001172s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.018304s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001039s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.022884s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003516s ]
SELECT * FROM `stock_search` WHERE `partno` = 'ANM5' LIMIT 1 [ RunTime:0.057466s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 20:29:04' WHERE `partno` = 'ANM5' [ RunTime:0.041716s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002673s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041713s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13813989 LIMIT 5 [ RunTime:0.032652s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.028721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813989 ORDER BY `minOrder` ASC [ RunTime:0.042927s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13813989 ORDER BY `unit` DESC [ RunTime:0.039532s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13813989 LIMIT 2 [ RunTime:0.079003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813989 ORDER BY `minOrder` ASC [ RunTime:0.010553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14704312 LIMIT 5 [ RunTime:0.082516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704312 ORDER BY `minOrder` ASC [ RunTime:0.037939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14704312 ORDER BY `unit` DESC [ RunTime:0.073817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14704312 LIMIT 2 [ RunTime:0.007070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704312 ORDER BY `minOrder` ASC [ RunTime:0.030604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14704313 LIMIT 5 [ RunTime:0.081675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704313 ORDER BY `minOrder` ASC [ RunTime:0.052241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14704313 ORDER BY `unit` DESC [ RunTime:0.035818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14704313 LIMIT 2 [ RunTime:0.099970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704313 ORDER BY `minOrder` ASC [ RunTime:0.013640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13813971 LIMIT 5 [ RunTime:0.106939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813971 ORDER BY `minOrder` ASC [ RunTime:0.095183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13813971 ORDER BY `unit` DESC [ RunTime:0.098325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13813971 LIMIT 2 [ RunTime:0.092711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813971 ORDER BY `minOrder` ASC [ RunTime:0.035945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16627502 LIMIT 5 [ RunTime:0.045419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16627502 ORDER BY `minOrder` ASC [ RunTime:0.098359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16627502 ORDER BY `unit` DESC [ RunTime:0.087975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16627502 LIMIT 2 [ RunTime:0.088304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16627502 ORDER BY `minOrder` ASC [ RunTime:0.028193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14704314 LIMIT 5 [ RunTime:0.020899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704314 ORDER BY `minOrder` ASC [ RunTime:0.114954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14704314 ORDER BY `unit` DESC [ RunTime:0.036867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14704314 LIMIT 2 [ RunTime:0.050161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704314 ORDER BY `minOrder` ASC [ RunTime:0.029574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14704315 LIMIT 5 [ RunTime:0.030544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704315 ORDER BY `minOrder` ASC [ RunTime:0.063624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14704315 ORDER BY `unit` DESC [ RunTime:0.070165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14704315 LIMIT 2 [ RunTime:0.045114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704315 ORDER BY `minOrder` ASC [ RunTime:0.079823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13813950 LIMIT 5 [ RunTime:0.042821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813950 ORDER BY `minOrder` ASC [ RunTime:0.079704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13813950 ORDER BY `unit` DESC [ RunTime:0.120852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13813950 LIMIT 2 [ RunTime:0.088349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813950 ORDER BY `minOrder` ASC [ RunTime:0.085309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13813972 LIMIT 5 [ RunTime:0.158900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813972 ORDER BY `minOrder` ASC [ RunTime:0.092264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13813972 ORDER BY `unit` DESC [ RunTime:0.119377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13813972 LIMIT 2 [ RunTime:0.117422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13813972 ORDER BY `minOrder` ASC [ RunTime:0.084675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14704316 LIMIT 5 [ RunTime:0.129539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704316 ORDER BY `minOrder` ASC [ RunTime:0.049322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14704316 ORDER BY `unit` DESC [ RunTime:0.135913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14704316 LIMIT 2 [ RunTime:0.068562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704316 ORDER BY `minOrder` ASC [ RunTime:0.048037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16627428 LIMIT 5 [ RunTime:0.041866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16627428 ORDER BY `minOrder` ASC [ RunTime:0.072021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16627428 ORDER BY `unit` DESC [ RunTime:0.033274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16627428 LIMIT 2 [ RunTime:0.050334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16627428 ORDER BY `minOrder` ASC [ RunTime:0.035406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14411850 LIMIT 5 [ RunTime:0.095309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14411850 ORDER BY `minOrder` ASC [ RunTime:0.048206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14411850 ORDER BY `unit` DESC [ RunTime:0.037112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14411850 LIMIT 2 [ RunTime:0.046952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14411850 ORDER BY `minOrder` ASC [ RunTime:0.013644s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029095s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.094290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192073 LIMIT 5 [ RunTime:0.023621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192073 ORDER BY `minOrder` ASC [ RunTime:0.025292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192073 ORDER BY `unit` DESC [ RunTime:0.010747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192073 LIMIT 2 [ RunTime:0.050497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192073 ORDER BY `minOrder` ASC [ RunTime:0.034820s ]
select * from pdf where partno='ANM58-2A' and brandshort='OptiFuse' limit 1 [ RunTime:0.052558s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-2A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.019435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192005 LIMIT 5 [ RunTime:0.021916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192005 ORDER BY `minOrder` ASC [ RunTime:0.052020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192005 ORDER BY `unit` DESC [ RunTime:0.040140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192005 LIMIT 2 [ RunTime:0.033029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192005 ORDER BY `minOrder` ASC [ RunTime:0.035318s ]
select * from pdf where partno='ANM58-30A' and brandshort='OptiFuse' limit 1 [ RunTime:0.072116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-30A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.015123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192006 LIMIT 5 [ RunTime:0.036519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192006 ORDER BY `minOrder` ASC [ RunTime:0.047766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192006 ORDER BY `unit` DESC [ RunTime:0.036341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192006 LIMIT 2 [ RunTime:0.045775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192006 ORDER BY `minOrder` ASC [ RunTime:0.017697s ]
select * from pdf where partno='ANM58-10A' and brandshort='OptiFuse' limit 1 [ RunTime:0.008210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-10A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.046775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192007 LIMIT 5 [ RunTime:0.009761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192007 ORDER BY `minOrder` ASC [ RunTime:0.040831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192007 ORDER BY `unit` DESC [ RunTime:0.053351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192007 LIMIT 2 [ RunTime:0.111828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192007 ORDER BY `minOrder` ASC [ RunTime:0.026444s ]
select * from pdf where partno='ANM58-5A' and brandshort='OptiFuse' limit 1 [ RunTime:0.058313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-5A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.028666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192008 LIMIT 5 [ RunTime:0.027005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192008 ORDER BY `minOrder` ASC [ RunTime:0.060602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192008 ORDER BY `unit` DESC [ RunTime:0.038273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192008 LIMIT 2 [ RunTime:0.021154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192008 ORDER BY `minOrder` ASC [ RunTime:0.022482s ]
select * from pdf where partno='ANM58-20A' and brandshort='OptiFuse' limit 1 [ RunTime:0.032291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-20A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.036777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192009 LIMIT 5 [ RunTime:0.053429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192009 ORDER BY `minOrder` ASC [ RunTime:0.029343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192009 ORDER BY `unit` DESC [ RunTime:0.048654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192009 LIMIT 2 [ RunTime:0.036045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192009 ORDER BY `minOrder` ASC [ RunTime:0.020501s ]
select * from pdf where partno='ANM58-25A' and brandshort='OptiFuse' limit 1 [ RunTime:0.055765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-25A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.034560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58191950 LIMIT 5 [ RunTime:0.012925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58191950 ORDER BY `minOrder` ASC [ RunTime:0.010067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58191950 ORDER BY `unit` DESC [ RunTime:0.020068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58191950 LIMIT 2 [ RunTime:0.023204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58191950 ORDER BY `minOrder` ASC [ RunTime:0.054986s ]
select * from pdf where partno='ANM58-3A' and brandshort='OptiFuse' limit 1 [ RunTime:0.036837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-3A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.034704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192010 LIMIT 5 [ RunTime:0.066535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192010 ORDER BY `minOrder` ASC [ RunTime:0.034849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192010 ORDER BY `unit` DESC [ RunTime:0.046908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192010 LIMIT 2 [ RunTime:0.052667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192010 ORDER BY `minOrder` ASC [ RunTime:0.001622s ]
select * from pdf where partno='ANM58-4A' and brandshort='OptiFuse' limit 1 [ RunTime:0.031342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-4A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.025332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192011 LIMIT 5 [ RunTime:0.027259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192011 ORDER BY `minOrder` ASC [ RunTime:0.017407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192011 ORDER BY `unit` DESC [ RunTime:0.064041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192011 LIMIT 2 [ RunTime:0.052004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192011 ORDER BY `minOrder` ASC [ RunTime:0.004974s ]
select * from pdf where partno='ANM58-7.5A' and brandshort='OptiFuse' limit 1 [ RunTime:0.016836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-7.5A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.022099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192216 LIMIT 5 [ RunTime:0.039893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192216 ORDER BY `minOrder` ASC [ RunTime:0.049063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192216 ORDER BY `unit` DESC [ RunTime:0.031761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192216 LIMIT 2 [ RunTime:0.121206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192216 ORDER BY `minOrder` ASC [ RunTime:0.020806s ]
select * from pdf where partno='ANM58-1A' and brandshort='OptiFuse' limit 1 [ RunTime:0.076975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-1A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.125273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58192013 LIMIT 5 [ RunTime:0.029790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192013 ORDER BY `minOrder` ASC [ RunTime:0.075302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58192013 ORDER BY `unit` DESC [ RunTime:0.033564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58192013 LIMIT 2 [ RunTime:0.023488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58192013 ORDER BY `minOrder` ASC [ RunTime:0.044536s ]
select * from pdf where partno='ANM58-15A' and brandshort='OptiFuse' limit 1 [ RunTime:0.033406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM58-15A' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.013359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63456738 LIMIT 5 [ RunTime:0.041945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63456738 ORDER BY `minOrder` ASC [ RunTime:0.046394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63456738 ORDER BY `unit` DESC [ RunTime:0.033950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63456738 LIMIT 2 [ RunTime:0.017876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63456738 ORDER BY `minOrder` ASC [ RunTime:0.001964s ]
select * from pdf where partno='ANM5' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.044281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANM5' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.031373s ]
SELECT `id` FROM `stock` WHERE `id` <> 63456738 AND `partno` = 'ANM5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.035802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14411850 [ RunTime:0.020417s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046720s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014300s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028999s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012775s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008731s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010462s ]
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 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005921s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ANM5%' OR `brand` LIKE 'ANM5%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021756s ]