SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316617 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316617 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162887,351965,535122,1004233,579558,633200,443553,437313,294077,707825,956936,355830,52919,139012,401228,378415,627885,554746,665036,118432,326008,447969,767121,857811,1024112,883038,120541,360370,379456,709854,140386,981629,938753,938157,400071,1032037,893792,85277,1036736,793597,571831,157676,799110,6395,377459,54818,162848,642565,804037,529690,123428,700935,757862,885184,418846,579062,656260,473241,623088,446754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000786s ]