SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403774 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403774 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562753,199839,650742,964153,14862,404396,786095,1024243,863288,902757,245851,187649,352916,197747,536284,474370,239985,281086,581401,123712,728609,114620,907856,199770,948852,870326,147797,506500,302341,882866,302374,303194,1009983,440712,370966,74782,637644,213495,509860,621809,582525,410406,603303,829271,163248,182891,405870,247215,1004932,1005720,976968,509238,309523,125857,580976,790454,113014,655137,64073,469967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]