SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283440 LIMIT 1 [ RunTime:0.001039s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283440 [ RunTime:0.002440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409704,380979,417880,979955,135652,861824,405324,509517,991548,324106,1007074,1024405,797045,67002,753648,1015034,78387,606852,683670,119004,480563,282998,976763,801454,749717,623650,702579,489760,963437,381032,537458,411408,510742,75812,758778,232942,112396,8460,833100,111473,967837,298274,649437,910928,288013,454402,127217,330677,108609,395041,5910,910004,795322,461193,42572,851039,99344,26172,166834,1036256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.040703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007531s ]