SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423835 LIMIT 1 [ RunTime:0.001152s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423835 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129253,1034220,711320,425451,624054,241698,149291,519035,587533,71843,369059,589390,44598,1028679,328029,73163,778736,588923,389160,291051,326208,982163,471138,660027,20926,371967,562294,821829,517707,41783,159144,762581,182570,196288,846918,396430,755087,941544,480155,998862,770268,584184,149726,653675,908876,923488,219724,1029876,430838,934818,841574,102133,29286,621769,858965,525414,358375,431409,862823,586943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423835 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423835 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001831s ]