SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042391 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042391 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158677,601333,301823,1041646,142398,119379,918041,846139,255699,235660,658707,891136,130258,437343,239161,261288,601758,563047,133150,661755,527302,508868,799669,220848,303184,1003816,971410,292165,869096,961006,489292,842757,691800,721880,752496,289258,530056,163526,139256,227901,522279,266352,954564,198346,150544,111490,208532,441115,345983,425413,730005,766312,351986,182437,935870,355918,420905,767604,787636,391856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]