SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039117 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039117 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911517,21959,698645,936506,441301,404542,323274,91420,856243,460200,971495,350163,134900,77103,674656,968861,399331,673418,908275,267004,571515,386587,531058,94173,460900,643556,940553,211170,854009,481800,727276,337277,291000,434303,589254,159740,312540,619318,956420,752167,373202,188276,24651,67724,91118,933278,297014,518616,44428,390349,288530,887097,542016,283514,420646,604081,978357,697511,987374,971167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]