SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336335 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336335 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152166,301968,183637,203655,246789,408125,935659,561137,335019,489194,345161,729917,248136,692001,3950,258127,201112,657258,193374,113569,377378,496007,689638,369701,537280,665442,458769,971496,864981,611210,118267,700366,812037,344053,498550,1003467,251005,582790,266257,873282,557270,21741,200414,64230,185571,224295,143233,108096,940237,222447,977728,340863,750306,675821,490429,762056,19866,684710,235383,327426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003562s ]