SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559096 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559096 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412742,480106,69763,825586,390805,737969,758036,57175,850407,280067,751809,716925,73105,897159,153297,1000667,815234,889699,747271,729810,971640,153871,789391,804011,55655,848913,46123,976561,208148,634970,1035228,356213,888200,814942,821141,761844,51720,110698,236802,579540,496207,665656,287735,802088,145972,443003,801990,997915,782320,669342,625148,789436,915020,835421,867142,1023097,499679,811594,63749,649582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]