SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002817s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.149' , `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=1%2F2A24-N20&search=1' [ RunTime:0.013195s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002330s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000609s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002608s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.149' ) [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002336s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002620s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002817s ]
SELECT * FROM `stock_search` WHERE `partno` = '1/2A24-N20' LIMIT 1 [ RunTime:0.021822s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-31 07:44:01' WHERE `partno` = '1/2A24-N20' [ RunTime:0.009446s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002244s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037847s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848949 LIMIT 5 [ RunTime:0.023187s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848949 ORDER BY `minOrder` ASC [ RunTime:0.024519s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848949 ORDER BY `unit` DESC [ RunTime:0.028655s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848949 LIMIT 2 [ RunTime:0.026352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848949 ORDER BY `minOrder` ASC [ RunTime:0.012606s ]
select * from pdf where partno='1/2A24-N20-I5-25PPM-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.021327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848946 LIMIT 5 [ RunTime:0.034318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848946 ORDER BY `minOrder` ASC [ RunTime:0.008942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848946 ORDER BY `unit` DESC [ RunTime:0.049349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848946 LIMIT 2 [ RunTime:0.048782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848946 ORDER BY `minOrder` ASC [ RunTime:0.007202s ]
select * from pdf where partno='1/2A24-N20-I10-25PPM-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.054940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848812 LIMIT 5 [ RunTime:0.063272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848812 ORDER BY `minOrder` ASC [ RunTime:0.029865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848812 ORDER BY `unit` DESC [ RunTime:0.023428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848812 LIMIT 2 [ RunTime:0.053179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848812 ORDER BY `minOrder` ASC [ RunTime:0.032697s ]
select * from pdf where partno='1/2A24-N20-I10-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.020717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848606 LIMIT 5 [ RunTime:0.101945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848606 ORDER BY `minOrder` ASC [ RunTime:0.018351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848606 ORDER BY `unit` DESC [ RunTime:0.035345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848606 LIMIT 2 [ RunTime:0.029107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848606 ORDER BY `minOrder` ASC [ RunTime:0.068390s ]
select * from pdf where partno='1/2A24-N20-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.033045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848577 LIMIT 5 [ RunTime:0.026440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848577 ORDER BY `minOrder` ASC [ RunTime:0.056030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848577 ORDER BY `unit` DESC [ RunTime:0.032492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848577 LIMIT 2 [ RunTime:0.050326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848577 ORDER BY `minOrder` ASC [ RunTime:0.023460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848565 LIMIT 5 [ RunTime:0.033633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848565 ORDER BY `minOrder` ASC [ RunTime:0.046348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848565 ORDER BY `unit` DESC [ RunTime:0.016830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848565 LIMIT 2 [ RunTime:0.018618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848565 ORDER BY `minOrder` ASC [ RunTime:0.005501s ]
select * from pdf where partno='1/2A24-N20-I10-25PPM-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.005241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848562 LIMIT 5 [ RunTime:0.000956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848562 ORDER BY `minOrder` ASC [ RunTime:0.003778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848562 ORDER BY `unit` DESC [ RunTime:0.017893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848562 LIMIT 2 [ RunTime:0.015894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848562 ORDER BY `minOrder` ASC [ RunTime:0.007287s ]
select * from pdf where partno='1/2A24-N20-I5-25PPM-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.034891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848537 LIMIT 5 [ RunTime:0.007221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848537 ORDER BY `minOrder` ASC [ RunTime:0.012315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848537 ORDER BY `unit` DESC [ RunTime:0.003477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848537 LIMIT 2 [ RunTime:0.010802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848537 ORDER BY `minOrder` ASC [ RunTime:0.016468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848530 LIMIT 5 [ RunTime:0.049691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848530 ORDER BY `minOrder` ASC [ RunTime:0.022822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848530 ORDER BY `unit` DESC [ RunTime:0.065993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848530 LIMIT 2 [ RunTime:0.046077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848530 ORDER BY `minOrder` ASC [ RunTime:0.011111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848447 LIMIT 5 [ RunTime:0.043392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848447 ORDER BY `minOrder` ASC [ RunTime:0.102929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848447 ORDER BY `unit` DESC [ RunTime:0.027439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848447 LIMIT 2 [ RunTime:0.103817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848447 ORDER BY `minOrder` ASC [ RunTime:0.032453s ]
select * from pdf where partno='1/2A24-N20-25PPM-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.025413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848406 LIMIT 5 [ RunTime:0.054077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848406 ORDER BY `minOrder` ASC [ RunTime:0.040693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848406 ORDER BY `unit` DESC [ RunTime:0.101026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848406 LIMIT 2 [ RunTime:0.086277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848406 ORDER BY `minOrder` ASC [ RunTime:0.023311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848373 LIMIT 5 [ RunTime:0.040041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848373 ORDER BY `minOrder` ASC [ RunTime:0.031732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848373 ORDER BY `unit` DESC [ RunTime:0.054218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848373 LIMIT 2 [ RunTime:0.076691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848373 ORDER BY `minOrder` ASC [ RunTime:0.037275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848346 LIMIT 5 [ RunTime:0.038698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848346 ORDER BY `minOrder` ASC [ RunTime:0.043137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848346 ORDER BY `unit` DESC [ RunTime:0.031828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848346 LIMIT 2 [ RunTime:0.074082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848346 ORDER BY `minOrder` ASC [ RunTime:0.020820s ]
select * from pdf where partno='1/2A24-N20-I10-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.048100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848344 LIMIT 5 [ RunTime:0.048249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848344 ORDER BY `minOrder` ASC [ RunTime:0.103324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848344 ORDER BY `unit` DESC [ RunTime:0.080368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848344 LIMIT 2 [ RunTime:0.078641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848344 ORDER BY `minOrder` ASC [ RunTime:0.011501s ]
select * from pdf where partno='1/2A24-N20-I5-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.076041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848329 LIMIT 5 [ RunTime:0.098629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848329 ORDER BY `minOrder` ASC [ RunTime:0.045541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848329 ORDER BY `unit` DESC [ RunTime:0.014335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848329 LIMIT 2 [ RunTime:0.009514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848329 ORDER BY `minOrder` ASC [ RunTime:0.025084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848325 LIMIT 5 [ RunTime:0.066840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848325 ORDER BY `minOrder` ASC [ RunTime:0.065096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848325 ORDER BY `unit` DESC [ RunTime:0.038072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848325 LIMIT 2 [ RunTime:0.034809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848325 ORDER BY `minOrder` ASC [ RunTime:0.024250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848271 LIMIT 5 [ RunTime:0.017704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848271 ORDER BY `minOrder` ASC [ RunTime:0.013018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848271 ORDER BY `unit` DESC [ RunTime:0.034573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848271 LIMIT 2 [ RunTime:0.024252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848271 ORDER BY `minOrder` ASC [ RunTime:0.014694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848266 LIMIT 5 [ RunTime:0.008676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848266 ORDER BY `minOrder` ASC [ RunTime:0.000945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848266 ORDER BY `unit` DESC [ RunTime:0.005899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848266 LIMIT 2 [ RunTime:0.022261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848266 ORDER BY `minOrder` ASC [ RunTime:0.014955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848260 LIMIT 5 [ RunTime:0.025821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848260 ORDER BY `minOrder` ASC [ RunTime:0.018500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848260 ORDER BY `unit` DESC [ RunTime:0.015277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848260 LIMIT 2 [ RunTime:0.037414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848260 ORDER BY `minOrder` ASC [ RunTime:0.007933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848154 LIMIT 5 [ RunTime:0.040369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848154 ORDER BY `minOrder` ASC [ RunTime:0.022864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848154 ORDER BY `unit` DESC [ RunTime:0.020327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848154 LIMIT 2 [ RunTime:0.001322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848154 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008319s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64371137 LIMIT 5 [ RunTime:0.022140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64371137 ORDER BY `minOrder` ASC [ RunTime:0.003918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64371137 ORDER BY `unit` DESC [ RunTime:0.012654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64371137 LIMIT 2 [ RunTime:0.023977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64371137 ORDER BY `minOrder` ASC [ RunTime:0.006511s ]
select * from pdf where partno='1/2A24-N20-F-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.001381s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1/2A24-N20-F-M' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.020495s ]
SELECT `id` FROM `stock` WHERE `id` <> 64371137 AND `partno` = '1/2A24-N20-F-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.010297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13892714 [ RunTime:0.009261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370686 LIMIT 5 [ RunTime:0.008497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370686 ORDER BY `minOrder` ASC [ RunTime:0.030261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370686 ORDER BY `unit` DESC [ RunTime:0.008260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370686 LIMIT 2 [ RunTime:0.018375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370686 ORDER BY `minOrder` ASC [ RunTime:0.007875s ]
select * from pdf where partno='1/2A24-N20-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.016802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1/2A24-N20-M' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.004738s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370686 AND `partno` = '1/2A24-N20-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.048511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649020 [ RunTime:0.040291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370465 LIMIT 5 [ RunTime:0.016043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370465 ORDER BY `minOrder` ASC [ RunTime:0.030180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370465 ORDER BY `unit` DESC [ RunTime:0.013777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370465 LIMIT 2 [ RunTime:0.029681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370465 ORDER BY `minOrder` ASC [ RunTime:0.007237s ]
select * from pdf where partno='1/2A24-N20-I5' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.043988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1/2A24-N20-I5' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.060396s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370465 AND `partno` = '1/2A24-N20-I5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.011107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13892028 [ RunTime:0.027617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370462 LIMIT 5 [ RunTime:0.035840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370462 ORDER BY `minOrder` ASC [ RunTime:0.037849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370462 ORDER BY `unit` DESC [ RunTime:0.059795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370462 LIMIT 2 [ RunTime:0.062274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370462 ORDER BY `minOrder` ASC [ RunTime:0.038565s ]
select * from pdf where partno='1/2A24-N20-I10' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.034188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1/2A24-N20-I10' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.031085s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370462 AND `partno` = '1/2A24-N20-I10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.051108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13892451 [ RunTime:0.050418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370337 LIMIT 5 [ RunTime:0.056573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370337 ORDER BY `minOrder` ASC [ RunTime:0.016338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370337 ORDER BY `unit` DESC [ RunTime:0.039083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370337 LIMIT 2 [ RunTime:0.035701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370337 ORDER BY `minOrder` ASC [ RunTime:0.007231s ]
select * from pdf where partno='1/2A24-N20-H' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.039575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1/2A24-N20-H' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.116792s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370337 AND `partno` = '1/2A24-N20-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.084603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14786723 [ RunTime:0.072550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64369936 LIMIT 5 [ RunTime:0.058265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64369936 ORDER BY `minOrder` ASC [ RunTime:0.107025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64369936 ORDER BY `unit` DESC [ RunTime:0.034997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64369936 LIMIT 2 [ RunTime:0.065377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64369936 ORDER BY `minOrder` ASC [ RunTime:0.066821s ]
select * from pdf where partno='1/2A24-N20' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.109255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1/2A24-N20' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.071415s ]
SELECT `id` FROM `stock` WHERE `id` <> 64369936 AND `partno` = '1/2A24-N20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.123953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16648552 [ RunTime:0.155025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58180762 LIMIT 5 [ RunTime:0.169117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58180762 ORDER BY `minOrder` ASC [ RunTime:0.079477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58180762 ORDER BY `unit` DESC [ RunTime:0.045526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58180762 LIMIT 2 [ RunTime:0.058118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58180762 ORDER BY `minOrder` ASC [ RunTime:0.034179s ]
select * from pdf where partno='1/2A24-N20-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.058448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1/2A24-N20-E' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.031306s ]
SELECT `id` FROM `stock` WHERE `id` <> 58180762 AND `partno` = '1/2A24-N20-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.042648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800104 [ RunTime:0.041724s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072961s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.113361s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045208s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077853s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.088919s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085969s ]
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 '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.149272s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1/2A24-N20%' OR `brand` LIKE '1/2A24-N20%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.111321s ]