SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310763 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310763 [ RunTime:0.002838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594740,802933,916482,261275,830453,1046900,21844,761857,778431,365274,535881,611203,168791,711878,858920,650903,892371,238379,601745,1011292,149191,648960,321001,829321,924374,935295,593356,81084,692107,197549,27675,760171,285901,491659,252937,253014,233929,1015726,139615,404254,4993,700811,718875,343650,471151,856407,802309,627678,878911,134161,876145,956800,783856,605141,106828,38346,602216,79547,620133,300904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]