SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103905 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103905 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689772,727556,922588,415992,578758,547757,211080,2899,506137,502539,732314,719524,226757,980798,776804,897696,319348,183787,1044068,271878,1021172,160544,682417,33091,234929,368875,361909,293454,556388,130493,615783,34377,321357,427521,28342,600430,673071,198828,1045448,789726,209007,500209,130456,436608,448863,879132,410598,792553,272747,767288,172185,167146,852459,739706,975093,498874,1046708,309869,254262,819000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]