SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415092 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415092 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560825,905849,145773,297522,901813,366249,660917,698825,182078,768970,689541,912032,624989,597942,55319,274436,187969,548656,208231,483691,51225,248150,901029,180141,191336,411637,682038,724206,950313,783781,802778,284507,439625,702681,180404,565953,517980,838967,656333,193876,1048397,303195,296662,811418,426746,144636,577940,681614,37069,747541,521215,765102,149353,655435,776380,959856,591025,301975,443696,84440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]