SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036392 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036392 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429978,395496,43708,1017995,847654,676943,522672,281987,402106,754696,106513,200665,418344,778256,358793,1048342,678642,507640,30584,331981,473945,18359,189109,932435,448372,504937,80360,43776,556310,417688,568527,943264,592746,795905,808678,541307,239422,807798,826863,694355,237385,651361,949312,936449,451287,346881,474737,690130,275616,831823,488398,826932,714936,418064,328707,914453,118254,335916,1013426,824066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]