SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540118 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540118 [ RunTime:0.004138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277825,542809,27928,217948,1028888,50078,779629,949399,672454,443048,41911,352123,306336,7713,577652,1018779,965020,686998,964632,333262,499524,126425,548191,745867,134864,542323,1027951,1012258,609189,268559,469176,464017,549890,412813,161461,304576,150668,957460,506991,317687,561283,971124,78613,28302,638527,708260,987145,841695,523007,905720,740170,946312,422423,422177,270097,306398,1001385,851815,797545,311834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]