SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031327 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031327 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407803,423503,115013,271704,56907,888130,233992,460192,960170,461143,135710,717558,512800,582492,264393,433047,196609,173104,130225,91655,1029075,910884,124012,985217,509103,727019,464581,546958,400104,425107,310494,731068,297978,37595,870806,662726,788444,683527,567092,463939,1003508,734236,983463,655005,636465,524018,688812,581129,722068,578163,210937,955544,268838,373045,335693,629695,988193,681083,767814,868754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]