SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914011 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914011 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270775,370930,719566,117188,324687,215740,367746,659915,234426,1025852,750469,421965,976080,793538,140158,885923,924656,1027190,377998,465801,369922,827869,1009031,148570,1014985,386872,727030,613857,415529,248803,172514,617857,127431,26678,249137,300799,161564,504028,97374,130903,389419,481438,703799,406768,187879,634322,733069,33942,984166,1015971,575116,692620,477515,793160,257823,673298,440651,650052,685285,447202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]