SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485816 LIMIT 1 [ RunTime:0.000743s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485816 [ RunTime:0.004756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457969,380537,629741,888788,748127,1003808,298384,64142,166823,1027106,401051,769002,402114,178200,606332,546361,811117,440597,479298,578831,1014101,58673,128807,648746,349013,865362,130871,889687,693940,696642,902080,999441,285016,567881,911175,1027270,725896,68440,731704,843011,47229,156122,391073,519326,601210,574664,358991,764783,1021922,239937,840243,562326,486154,972080,257647,202229,196341,985289,596259,900408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]