SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564621 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564621 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018864,611274,1031486,250580,971745,89267,658196,802494,499828,860944,933602,82155,300099,941069,609024,391307,512109,786317,372527,74380,58458,315100,922892,668707,801320,663704,562093,656082,245638,362714,589813,543238,297004,75619,102561,952856,690553,317576,235946,826510,905212,628860,159016,223251,1035883,1030737,992332,120466,612617,130719,990584,658013,684205,34600,469468,767163,173336,30335,190512,598751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000794s ]