SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41912 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41912 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016591,165559,669356,1012396,596420,106857,206330,33288,260973,415694,386225,38104,889792,488593,686570,816047,854090,1028486,622957,836352,377274,741258,957743,802596,514771,502562,349061,167021,547864,272504,224558,543240,376951,785993,54119,316671,135955,104619,1014402,909960,540475,536894,440602,826886,897129,458974,276995,977689,590612,601494,661063,498166,760041,727981,1021540,258785,219086,111327,167742,161413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]