SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520894 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520894 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427967,723185,464419,228378,157855,103856,831615,452746,564625,840092,780958,715507,617881,796278,740608,37530,787201,913817,669045,347813,371291,193014,363631,357283,448482,257083,460246,1043402,1036677,43657,519248,147017,455557,755858,221130,172656,754310,738737,691111,663160,309114,502265,65778,80187,134036,837918,650299,169921,262624,380122,701793,528675,789148,621505,1008850,350867,1018226,419956,948464,160279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]