SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571918 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571918 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328420,538867,789094,373558,862626,684561,907150,259263,55023,105515,807150,203069,497918,718706,406814,427845,229809,251483,670800,685673,797082,163012,2566,505083,179218,35852,253760,862484,929753,960841,692554,601387,543136,981534,176945,353568,942585,103101,764914,873185,10656,256080,83564,517039,146931,613110,539574,558679,120255,427042,30892,124462,303141,392183,662650,139104,83644,1006185,381686,108326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]