SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 228100 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 228100 [ RunTime:0.002552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852907,504981,931662,608722,1005226,347250,912212,480272,434848,645988,706968,697616,131803,772187,370887,728166,291503,1046921,198705,125827,867101,378180,472632,758645,911673,1034131,271528,421714,275679,450490,982329,238846,100132,69961,980228,578983,736607,442603,805047,656159,263975,308948,748267,800128,603390,860291,786549,160010,526040,814413,542250,661384,360177,226635,5568,152542,485956,971896,14995,251725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 228100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 228100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]