SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004793s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293981 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293981 [ RunTime:0.001418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794583,601383,357552,179835,555541,408970,412566,160915,812364,190807,778587,1031679,150663,271509,774013,65213,466344,162159,707422,825248,247101,17220,230056,793395,915756,441659,536483,389397,616388,956088,1001275,618687,1015617,757836,256562,142699,514806,121540,631485,832804,620230,43605,618305,725725,961705,875899,483304,538591,139341,913782,953509,246539,445146,547633,346988,822130,66442,119524,464400,782962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004783s ]