SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195168 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195168 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920016,590418,793505,769857,1016553,856532,418600,233063,335090,871198,911002,241868,946240,889355,1035700,171453,810295,626741,386052,528569,715470,212593,809187,997496,261446,188047,245965,388927,485271,142028,237073,625831,998384,182715,671819,683244,271402,859092,651420,252974,390637,152396,837447,901767,576760,753734,207366,977865,1033593,238346,364634,928262,490094,1007169,1002997,911775,993516,12348,388497,163328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]