SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40434 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40434 [ RunTime:0.007062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145638,342930,792991,544187,264286,501705,160588,162679,522240,459168,501552,511020,812874,112840,915551,915532,519230,604845,713046,103621,847763,910049,426923,222593,560276,102020,283860,514388,1045666,629726,674131,603950,354328,598374,115121,676041,938493,1028779,555146,648297,825276,335570,73038,556052,633565,83031,11869,17858,422937,237684,25959,964669,608762,568896,468558,898807,255999,17430,644380,1017439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]