SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458203 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458203 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972391,1021047,784678,271561,682448,987217,184388,736263,229192,686652,919226,542767,660553,55399,296768,320027,133954,320909,195336,350603,180008,219572,804472,236427,382466,838397,422262,435876,825583,209251,564865,202911,873149,692046,746248,684968,825871,670014,828983,772771,1012932,920883,738284,357008,321625,313917,339033,67473,589799,524685,176611,169158,92953,770257,244123,727602,916091,508745,690852,930970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]