SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509831 LIMIT 1 [ RunTime:0.000685s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509831 [ RunTime:0.002269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322699,970429,1048914,394397,569778,38928,610133,72662,438790,443865,831986,35815,94910,663847,1035499,898179,319893,775241,461117,932029,290887,826746,81123,370066,1024978,730787,934260,871876,325576,553241,997306,716341,912252,124517,44938,206532,268992,214932,982371,1041697,958363,973077,25104,416890,268749,371947,953912,568547,237439,46783,1046255,856718,403541,260949,465415,601383,707298,120664,30891,845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]