SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025079 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025079 [ RunTime:0.002416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620656,354251,620394,129993,124960,487895,1041845,528106,846417,92157,283223,403626,973189,386735,775917,447099,527594,519062,671795,1026148,207134,100557,62438,550406,902945,739918,993457,678865,235104,291221,108997,225896,22987,181025,261547,183752,303159,86967,218992,303771,177526,240796,533188,591277,587212,442533,918604,375879,679226,24831,275533,964741,453195,466719,582573,799248,651438,603071,173319,96182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]