SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027924 LIMIT 1 [ RunTime:0.001131s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027924 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390049,58004,955048,473327,308617,434668,817973,444558,207660,94737,667065,56604,961855,337672,126538,284066,43447,432303,866647,840754,785379,1010872,815297,455422,258116,141335,715211,504385,992797,869180,885726,677944,753816,154881,401074,156306,268900,422334,654338,1032856,787530,636036,631027,343308,866560,860708,708060,694004,628240,612962,411962,430514,744601,441778,518148,537862,44494,497338,707094,932464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]