SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518818 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518818 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895052,162887,100925,620200,996247,684160,913260,731314,785441,264093,879746,1007620,10154,466429,132420,837722,688955,892403,983421,365219,186922,429419,740178,969275,863026,89297,648694,1015207,56262,336545,43269,57169,98290,760799,179059,16749,161703,370922,672707,188608,196527,399290,205373,606311,626288,677138,44024,1011927,613622,827662,402307,845091,106816,1043413,912632,901363,251520,901040,147569,297371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]