SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549401 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549401 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796563,936708,436782,193901,799332,697219,759867,853663,751832,97353,720164,949937,357754,588131,443358,940809,149642,941045,634384,344610,317622,494512,762153,326193,324437,629243,623473,331722,394086,120804,768326,85584,985854,896922,277619,134346,826879,768373,499321,285766,663115,418471,677776,833469,890195,697801,752127,1022827,654306,716222,1018566,503843,795501,870943,503481,190282,972124,328968,109549,345221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]