SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507911 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507911 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474568,646964,198707,941119,977278,426615,626230,452598,150804,771992,454063,795500,738980,233319,403948,362869,167895,336195,864962,963650,1004490,784043,83658,137451,1036220,347437,524291,567119,847446,579986,339155,926752,105688,641982,786615,288459,746681,21733,947590,891995,670553,480825,202319,414024,405441,166764,617944,914402,414355,979270,953496,30144,360117,58016,788142,687992,1017698,558024,1033518,430666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]