SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483841 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483841 [ RunTime:0.001436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506009,169103,886335,600186,95087,791775,27275,1022985,94642,189863,1028433,943418,412424,564984,181485,950689,964951,1030315,243099,22650,945446,444757,386075,920735,555952,925587,599430,865297,638009,945463,350020,213636,345398,621313,408764,583364,983470,739350,146134,960448,953034,477385,566101,55647,443174,165269,824382,654752,1034027,718214,245523,1033502,444370,947136,393592,102976,596089,445026,41591,939020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]