SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568396 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568396 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020727,98283,172789,801842,104088,308916,506420,297322,528229,896436,525387,492395,427503,952177,102534,1034947,356965,990528,896684,424689,625191,809236,38849,1018118,146644,920977,989771,670081,184868,327679,834208,660288,460139,468309,865336,569489,895717,185794,437517,185816,653590,14969,936455,366009,77154,970308,351402,551914,452750,467744,244285,1000951,559926,173634,419511,1017963,184147,340453,10896,678297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]