SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537810 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537810 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193173,304685,1025903,198517,104465,94952,838966,315097,97716,365866,876324,167883,1038687,463666,756351,303954,146558,976125,684253,386320,913348,424407,341611,602769,12197,803683,651196,606275,205210,118307,501874,578934,794549,111977,697262,549339,509258,296148,329384,928709,297428,585393,125152,845249,100001,220243,732303,165003,22631,191708,611257,313523,826720,684531,741324,103411,7710,448271,216377,655183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]