SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396449 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396449 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020649,442047,883422,331376,675456,776390,747826,737373,451042,360106,861327,977954,627416,947005,643179,229289,609003,10790,356344,892123,932517,600770,746281,314585,930612,501695,919074,614887,834760,1041760,62134,136446,522520,336573,913347,1022949,657174,556732,243904,135887,191873,795029,796843,410362,265974,870428,123054,915728,360591,710651,911040,540472,193952,312053,770066,708616,640887,667718,921765,963735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]