SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294933 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294933 [ RunTime:0.001452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528915,776371,98707,554368,879452,696014,481919,883306,410277,1010380,1037495,982691,656633,204864,482711,1026161,626599,714145,977038,413511,967969,610567,701618,687318,492017,606670,797532,936902,669865,742791,1018789,407810,837495,12014,366016,111116,222859,8107,593213,275708,141415,536955,630203,124860,1048757,435893,956831,124096,456284,180639,474869,591304,825105,708278,62653,528706,232281,639775,268611,904798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]