SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532117 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532117 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135129,866241,22670,1011405,717298,135997,149849,391878,242230,706744,445566,623524,238513,203747,291382,483009,734082,183246,473719,436762,262095,894584,577598,839347,988121,1017679,739829,789130,870867,590532,629612,756792,390691,220941,499800,45751,83908,194106,313003,33304,928099,149315,972239,164844,241836,370875,830029,427751,123915,304202,398822,76662,702995,131402,145785,504579,1006953,650751,771254,1007973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]