SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298501 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298501 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105899,490277,889890,106670,875571,70831,219998,718625,188655,53567,986398,613170,671575,948042,101591,626143,152151,997661,445398,726782,307478,726683,314423,562319,991805,1046709,930710,669653,252807,607532,585291,57025,894200,778168,274820,721904,958754,985201,438895,247209,161011,547977,565262,257767,424055,591691,784151,108756,104840,29130,754788,508985,944305,315150,902944,685981,472599,605765,957438,167213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]