SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294928 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294928 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111352,715963,104054,486931,658264,24384,535754,714843,362945,873305,264375,786532,561948,544150,1009194,718998,1009145,689451,152692,212683,962304,505487,356612,208526,1020101,574744,720161,872623,469471,28858,308754,69499,1046587,314236,262953,587163,41977,773500,252067,796915,962281,57338,631614,1046135,443370,673100,747992,198322,727999,225818,504045,839864,929536,713346,167143,497467,243421,708671,652017,410861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]