SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683331 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683331 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196921,223888,231264,949661,644339,969330,484208,642282,237202,222662,704412,940138,1024901,141523,59644,340609,727297,615002,379006,111133,466505,831969,257220,550569,594,271320,137099,892618,194149,1011204,139281,974500,510114,843583,283252,174308,845842,493046,13303,59217,818130,154373,919503,151809,607198,34535,174820,663110,1005172,897425,292457,807337,26532,3665,452768,79293,106497,60348,470823,168483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]