SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001812s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494987 LIMIT 1 [ RunTime:0.001777s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494987 [ RunTime:0.007748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753211,119874,924441,1022881,120982,99578,266346,813936,480576,48194,111254,156174,247455,707101,967554,151695,714218,274401,667827,810713,158013,889633,408068,225035,908047,884332,551073,458857,682541,82295,901577,957543,985361,821140,953278,149540,925064,279174,568890,849986,416,79333,718002,465874,767695,1043518,722590,913903,1007056,146087,616200,734914,117531,19290,198475,753235,321991,925885,418670,940463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002598s ]