SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425823 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425823 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217120,221826,700798,119664,291574,626271,558918,438442,678362,529291,367900,989692,1047565,877242,245988,67720,940610,803575,1020925,596831,10211,1042599,125708,373944,483841,276142,434938,255161,955737,211684,651482,142947,446742,507160,204018,120211,34137,136601,826547,454339,378676,141173,800657,328516,524171,950118,483026,758318,801916,420490,244314,113170,783290,261408,148048,316162,174285,447761,262423,160923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]