SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477861 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477861 [ RunTime:0.002543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611673,209640,331535,667352,469480,282371,542911,420895,1042174,428562,212597,831072,215350,126381,472453,1015593,311609,791540,367587,206938,268631,1010811,617900,886989,522522,566351,238867,32704,456478,460932,1004348,475086,324481,106873,377254,1048345,2989,535347,930526,301155,520188,1016103,918043,676201,217590,367935,403835,116984,983383,45919,707614,189000,510629,889185,28681,1004054,493313,886775,794557,14349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]