SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412770 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412770 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844613,129962,733730,801984,132367,440087,36465,489217,530136,703989,530392,880811,114814,717663,911611,152658,321920,987160,789589,764556,875865,321343,135629,248560,51037,553804,135142,656381,524213,447462,451455,131250,699787,186311,930753,282506,205748,823455,827389,452124,81060,251237,262584,115431,129326,835655,762412,323375,347802,425186,101696,78400,758506,233179,427699,347728,609816,854250,355041,426753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001460s ]