SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526438 LIMIT 1 [ RunTime:0.000753s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526438 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887084,92850,218277,521651,603407,478347,686357,537644,899201,431721,622684,797369,986412,182263,683686,84848,265304,219132,915703,918431,1018706,930480,598832,19242,7627,757511,232756,401428,352715,864294,747729,269504,986863,672470,620870,191472,544515,610891,231756,621381,876931,974953,811432,476209,602688,180848,998959,1033073,669963,103688,287372,218540,878197,390498,228917,239591,55589,814663,106036,680510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000368s ]