SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406687 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406687 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470569,902843,464075,183135,322083,1017062,622239,921688,933454,160587,815118,959191,612254,473723,742746,671148,927415,849512,971634,59384,5226,843021,1001138,873740,690318,427343,617907,1016296,559937,172679,326936,710308,912533,297946,248776,115160,919535,380094,322988,1020183,226402,89653,263167,733112,1040464,55477,515050,746652,157340,287161,226893,1027097,949921,790715,723396,511917,29720,689899,603153,616035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]