SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001601 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001601 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108975,1005918,89181,929224,201735,972616,69501,282654,223021,658207,293586,616531,324026,817618,421536,98989,382642,547595,992775,815603,682846,27586,448068,841595,894530,2104,224787,127475,641047,201221,433519,691635,902607,647891,971899,796083,422015,986146,911711,125936,30437,564006,945906,77344,866644,464696,230344,521207,109075,94820,1033764,988862,766230,619398,807431,371224,911412,686735,986040,949597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]