SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012150 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012150 [ RunTime:0.001390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101304,444095,352051,700214,127418,717285,811103,705854,473875,1021019,184219,819862,626131,489235,27265,190647,1048170,183458,945047,934756,681398,871092,789786,611455,431084,612884,680483,705478,428790,885876,307657,854422,623484,510737,900210,1026351,419204,44986,289044,114655,712382,797298,514575,184229,510273,902441,86056,623404,920823,892851,719997,1046038,323124,992164,414934,520631,512997,731121,717475,975836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]