SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255980 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255980 [ RunTime:0.002415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564342,42136,535658,60837,52704,375374,919591,46860,386976,288115,316342,141635,713625,670691,998971,613700,589411,618639,671083,723291,581708,318586,225022,908692,811213,508003,449924,539194,386074,730297,303614,718460,265990,891726,735813,580123,175013,524098,625057,848656,214702,955631,170952,281744,183864,396889,79109,159121,859776,561313,651033,712119,322806,460259,603831,935061,289150,188181,17879,424609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]