SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801246 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801246 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917724,473268,987070,553495,734841,417027,267126,6408,611810,1017344,620917,264222,836532,236243,910491,221809,505153,889588,700271,21047,699218,1048706,118717,93864,550123,841474,747355,541025,757088,189299,555489,1003799,1023459,301556,365262,192588,788124,253197,936633,840533,687865,82416,364880,1045155,684877,463725,983884,620338,753585,306451,733945,838315,735918,287991,445175,706014,944724,407427,420114,598132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001765s ]